完善资料让更多小伙伴认识你,还能领取20积分哦, 立即完善>
嗨Tom,在过去的项目中,我遇到了使用EXCEL加载项中的函数的问题。
解决方案是停用加载项,然后再次激活它..xlApp.AddIns(“analysis toolpak”)。Installed = FALSE; xlApp.AddIns(“analysis toolpak - vba”)。Installed = FALSE; xlApp.AddIns(“ 分析toolpak“)。Installed = TRUE; xlApp.AddIns(”analysis toolpak - vba“)。Installed = TRUE;我向Microsoft报告此问题并且他们有相同的行为。无论如何你应该停用警告,比如马克告诉你 最好的问候。 Bernhardt --------------------------------------------- SOMATEC - Software fr Maschinensteuerungenund Automatisierungstechnik GbRJagdweg 7aD-82041 DeisenhofenTelefon:(089)613 984 94Fax:(089)613 981 23Email:Bernhardt@somatec.dehomepage:www.somatec.com ----------------- ---------------------------- ----- Ursprngliche Nachricht ----- Von:Goldberg,Mark [mailto:Mark。 Goldberg@ATK.COM] Gesendet:Freitag,2003年11月21日16:09安:VRFBetreff:[vrf] RE:Excel和Excel的奇怪问题 VEETom,不确定如何做你要求的,但你可能会尝试:ExcelApp.DisplayAlerts = FALSE;如果我没记错,这可以防止显示消息。 Justmake确定你以编程方式处理任何错误,否则你可能会遇到麻烦.Mark -----原始消息-----来自:Thomas.Mitchell@Autoliv.com [mailto:Thomas.Mitchell@Autoliv.com]发送: 2003年11月21日星期五凌晨4点31分:VRFS主题:[vrf] Excel和Excel的奇怪问题 VEEI有一个奇怪的问题,真让我难过。 我有一个测试程序,我在大约5 - 6年前开始工作。 这个计划多年来一直在发展。 我开始使用DDE和Excel,现在我开始使用ActiveX重写一些用户功能。 作为我的测试程序的一部分,我从其中一个模块上的嵌入式微提取中提取了一个S-Record。 然后将这些数据加载到不同的Excel电子表格中,并且有一些宏运行并将一些十六进制数据转换为十进制数据,并且它还将一些数据字节解码为用户容易理解的格式。现在我的问题 。 当我的一个同事给我这个Excel工具(也是原始的根源回到Excel 4.0?)时,我们试图加载我的inputdata文件,转换无法正常工作。 然后,他在Excel中检查我的加载项,并注意到我没有选中一个框。我们检查了该框,然后它要求安装磁盘加载该功能。 我们加载了该功能,我的Excel工具正常运行,但是我从Excel中收到一条奇怪的消息(参见附件)(参见附件:excel_error.bmp),询问我是否要替换resume.xlw。 我之前已经对此进行了监督。 这导致我的VEE程序挂起,因为它正在查找是或否答案。 我可以通过ActiveX YES或NO告诉它吗? 如果是这样,我怎么做? excelApp.YES()?谢谢,Tom MitchellAutoliv AEA ---您目前订阅了vrf:Bernhardt@somatec.de订阅时发送一封空白电子邮件至“join-vrf@it.lists.it.agilent.com”。 取消订阅会发送一封空白电子邮件至“leave-vrf@it.lists.it.agilent.com”。要向此邮件列表发送邮件,请发送电子邮件至“vrf@agilent.com”。 如果您需要有关邮件列表的帮助,请发送邮件至“owner-vrf@it.lists.it.agilent.com”.---您目前订阅vrf为:r***@soco.agilent.com要订阅发送空白 发送电子邮件至“join-vrf@it.lists.it.agilent.com”。要取消订阅,请发送一封空白电子邮件至“leave-vrf@it.lists.it.agilent.com”。要向此邮件列表发送邮件,请发送电子邮件至 “vrf@agilent.com”。 如果您需要有关邮件列表的帮助,请发送邮件至“owner-vrf@it.lists.it.agilent.com”。 以上来自于谷歌翻译 以下为原文 Hi Tom, in a past project I had a problem with using functions from add-ins from EXCEL. The solution was to deactivate the add-in and then activate it again. xlApp.AddIns("analysis toolpak").Installed = FALSE; xlApp.AddIns("analysis toolpak - vba").Installed =FALSE; xlApp.AddIns("analysis toolpak").Installed = TRUE; xlApp.AddIns("analysis toolpak - vba").Installed = TRUE; I reported this problem to Microsoft and they had the same behaviour. In any case you should deactivate the alerts like Mark told you. Best regards M. Bernhardt --------------------------------------------- SOMATEC - Software fr Maschinensteuerungen und Automatisierungstechnik GbR Jagdweg 7a D-82041 Deisenhofen Telefon : (089) 613 984 94 Fax : (089) 613 981 23 Email : Bernhardt@somatec.de homepage : www.somatec.com --------------------------------------------- -----Ursprngliche Nachricht----- Von: Goldberg, Mark [mailto:Mark.Goldberg@ATK.COM] Gesendet: Freitag, 21. November 2003 16:09 An: VRF Betreff: [vrf] RE: Strange problem with Excel & VEE Tom, Not sure how to do what you were asking for, but you might try: ExcelApp.DisplayAlerts =FALSE; If I remember correctly this prevents messages from being displayed. Just make sure you are taking of any errors programmatically or you could run into trouble. Mark -----Original Message----- From: Thomas.Mitchell@Autoliv.com [mailto:Thomas.Mitchell@Autoliv.com] Sent: Friday, November 21, 2003 4:31 AM To: VRF Subject: [vrf] Strange problem with Excel & VEE I have a strange problem that really has me stumped. I have a test program that I first started working on about 5-6 years ago. This program has really evolved over the years. I started out using DDE with Excel, and now I'm starting to rewrite some of the user function using ActiveX. As part of my test program, I extract an S-Record from an imbedded micro on one of our modules. This data is then loaded into a different Excel spreadsheet, and there are macros that run and convert some of the hex data to decimal, and it also decodes some of the data bytes in to a format that is easily understandable by the user. Now my problem. When one of my co-workers gave me this Excel tool (also evolving, original roots back to Excel 4.0?), we tried to load my input data file, and the conversion didn't work properly. He then went and checked my add-in's in Excel, and noticed that I didn't have a box checked. We checked the box, then it asked for the install disk to load that feature. We loaded the feature, and my Excel tool functions properly, but now I get a strange message from Excel (see attached) (See attached file: excel_error.bmp) asking me if I want to replace resume.xlw. I had never seen this before. This causes my VEE program to hang because it is looking for a YES or NO answer. Can I tell it via ActiveX YES or NO? If so, how do I do it? excelApp.YES()? Thanks, Tom Mitchell Autoliv AEA --- You are currently subscribed to vrf as: Bernhardt@somatec.de To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com". --- You are currently subscribed to vrf as: r***@soco.agilent.com To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com". |
|
相关推荐
1个回答
|
|
谢谢。
现在,我重新安装了Excel并完成了Mark告诉我要做的事情。我没有勇气尝试添加。 我明天去度假,很久以前我就知道你在度假前没有尝试过重大改变! 我4点回来的时候会试试这个。谢谢! Markus Bernhardt c.de> cc:主题:[vrf] AW:RE:Excel和Excel的奇怪问题 VEE 11/25/2003 07:32 AM请回复Markus Bernhardt嗨Tom,在过去的项目中,我在使用来自EXCEL的加载项中的函数时遇到了问题。解决方案是停用加载项然后再次激活它。 xlApp.AddIns(“analysis toolpak”)。Installed = FALSE; xlApp.AddIns(“analysis toolpak - vba”)。Installed = FALSE; xlApp.AddIns(“analysis toolpak”)。Installed = TRUE; xlApp.AddIns(“analysis” toolpak - vba“)。Installed = TRUE;我向微软报告了这个问题并且他们有相同的行为。无论如何你应该停用警告告诉你的警报。最好的问候M. Bernhardt --------------------------------------------- SOMATEC - Software fr Maschinensteuerungenund Automatisierungstechnik GbRJagdweg 7aD-82041 DeisenhofenTelefon:(089)613 984 94Fax:(089)613 981 23Email:Bernhardt@somatec.dehomepage:www.somatec.com ----------------- ---------------------------- ----- Ursprngliche Nachricht ----- Von:Goldberg,Mark [mailto:Mark。 Goldberg@ATK.COM] Gesendet:Freitag,2003年11月21日16:09安:VRFBetreff:[vrf] RE:Excel和Excel的奇怪问题 VEETom,不确定如何做你要求的,但你可能会尝试:ExcelApp.DisplayAlerts = FALSE;如果我没记错,这可以防止显示消息。 Justmake确定你以编程方式处理任何错误,否则你可能会遇到麻烦.Mark -----原始消息-----来自:Thomas.Mitchell@Autoliv.com [mailto:Thomas.Mitchell@Autoliv.com]发送: 2003年11月21日星期五凌晨4点31分:VRFS主题:[vrf] Excel和Excel的奇怪问题 VEEI有一个奇怪的问题,真让我难过。 我有一个测试程序,我在大约5 - 6年前开始工作。 这个计划多年来一直在发展。 我开始使用DDE和Excel,现在我开始使用ActiveX重写一些用户功能。 作为我的测试程序的一部分,我从其中一个模块上的嵌入式微提取中提取了一个S-Record。 然后将这些数据加载到不同的Excel电子表格中,并且有一些宏运行并将一些十六进制数据转换为十进制数据,并且它还将一些数据字节解码为用户容易理解的格式。现在我的问题 。 当我的一个同事给我这个Excel工具(也是原始的根源回到Excel 4.0?)时,我们试图加载我的inputdata文件,转换无法正常工作。 然后,他在Excel中检查我的加载项,并注意到我没有选中一个框。我们检查了该框,然后它要求安装磁盘加载该功能。 我们加载了该功能,我的Excel工具正常运行,但是我从Excel中收到一条奇怪的消息(参见附件)(参见附件:excel_error.bmp),询问我是否要替换resume.xlw。 我之前已经对此进行了监督。 这导致我的VEE程序挂起,因为它正在查找是或否答案。 我可以通过ActiveX YES或NO告诉它吗? 如果是这样,我怎么做? excelApp.YES()?谢谢,Tom MitchellAutoliv AEA ---您目前订阅了vrf:Bernhardt@somatec.de订阅时发送一封空白电子邮件至“join-vrf@it.lists.it.agilent.com”。 取消订阅发送空白电子邮件至“leave-vrf@it.lists.it.agilent.com”。要发送邮件到此邮件列表,请发送电子邮件至“vrf@agilent.com”。如果您需要有关邮件列表的帮助,请发送邮件 到“owner-vrf@it.lists.it.agilent.com”.---您目前订阅了vrf:Thomas.Mitchell@Autoliv.com订阅时发送一封空白电子邮件至“join-vrf@it.lists。 it.agilent.com“。要取消订阅,请发送空白电子邮件至”leave-vrf@it.lists.it.agilent.com“。要发送邮件到此邮件列表,请发送电子邮件至”vrf@agilent.com“。如果您需要 帮助邮件列表发送邮件给“owner-vrf@it.lists.it.agilent.com”.---您目前订阅了vrf:r***@soco.agilent.com要订阅,请发送空白电子邮件至“ join-vrf@it.lists.it.agilent.com“。要取消订阅,请发送空白电子邮件至”leave-vrf@it.lists.it.agilent.com“。要发送消息给 这个邮件列表,请发送电子邮件至“vrf@agilent.com”。 如果您需要有关邮件列表的帮助,请发送邮件至“owner-vrf@it.lists.it.agilent.com”。 以上来自于谷歌翻译 以下为原文 Thanks. For now, I re-installed Excel and did what Mark had told me to do. I don't have the nerve to try the add in's yet. I go on vacation tomorrow and I learned long ago that you don't try a major change just before going on vacation! I'll try this when I return on the 4th. Thanks! Markus Bernhardt c.de> cc: Subject: [vrf] AW: RE: Strange problem with Excel & VEE 11/25/2003 07:32 AM Please respond to Markus Bernhardt Hi Tom, in a past project I had a problem with using functions from add-ins from EXCEL. The solution was to deactivate the add-in and then activate it again. xlApp.AddIns("analysis toolpak").Installed = FALSE; xlApp.AddIns("analysis toolpak - vba").Installed =FALSE; xlApp.AddIns("analysis toolpak").Installed = TRUE; xlApp.AddIns("analysis toolpak - vba").Installed = TRUE; I reported this problem to Microsoft and they had the same behaviour. In any case you should deactivate the alerts like Mark told you. Best regards M. Bernhardt --------------------------------------------- SOMATEC - Software fr Maschinensteuerungen und Automatisierungstechnik GbR Jagdweg 7a D-82041 Deisenhofen Telefon : (089) 613 984 94 Fax : (089) 613 981 23 Email : Bernhardt@somatec.de homepage : www.somatec.com --------------------------------------------- -----Ursprngliche Nachricht----- Von: Goldberg, Mark [mailto:Mark.Goldberg@ATK.COM] Gesendet: Freitag, 21. November 2003 16:09 An: VRF Betreff: [vrf] RE: Strange problem with Excel & VEE Tom, Not sure how to do what you were asking for, but you might try: ExcelApp.DisplayAlerts =FALSE; If I remember correctly this prevents messages from being displayed. Just make sure you are taking of any errors programmatically or you could run into trouble. Mark -----Original Message----- From: Thomas.Mitchell@Autoliv.com [mailto:Thomas.Mitchell@Autoliv.com] Sent: Friday, November 21, 2003 4:31 AM To: VRF Subject: [vrf] Strange problem with Excel & VEE I have a strange problem that really has me stumped. I have a test program that I first started working on about 5-6 years ago. This program has really evolved over the years. I started out using DDE with Excel, and now I'm starting to rewrite some of the user function using ActiveX. As part of my test program, I extract an S-Record from an imbedded micro on one of our modules. This data is then loaded into a different Excel spreadsheet, and there are macros that run and convert some of the hex data to decimal, and it also decodes some of the data bytes in to a format that is easily understandable by the user. Now my problem. When one of my co-workers gave me this Excel tool (also evolving, original roots back to Excel 4.0?), we tried to load my input data file, and the conversion didn't work properly. He then went and checked my add-in's in Excel, and noticed that I didn't have a box checked. We checked the box, then it asked for the install disk to load that feature. We loaded the feature, and my Excel tool functions properly, but now I get a strange message from Excel (see attached) (See attached file: excel_error.bmp) asking me if I want to replace resume.xlw. I had never seen this before. This causes my VEE program to hang because it is looking for a YES or NO answer. Can I tell it via ActiveX YES or NO? If so, how do I do it? excelApp.YES()? Thanks, Tom Mitchell Autoliv AEA --- You are currently subscribed to vrf as: Bernhardt@somatec.de To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com". --- You are currently subscribed to vrf as: Thomas.Mitchell@Autoliv.com To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com". --- You are currently subscribed to vrf as: [email=r***@soco.agilent.com]r***@soco.agilent.com[/email] To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com". |
|
|
|
只有小组成员才能发言,加入小组>>
1038 浏览 0 评论
2282 浏览 1 评论
2068 浏览 1 评论
1942 浏览 5 评论
2811 浏览 3 评论
805浏览 1评论
关于Keysight x1149 Boundary Scan Analyzer
590浏览 0评论
N5230C用“CALC:MARK:BWID?”获取Bwid,Cent,Q,Loss失败,请问大佬们怎么解决呀
686浏览 0评论
2473浏览 0评论
1526浏览 0评论
小黑屋| 手机版| Archiver| 电子发烧友 ( 湘ICP备2023018690号 )
GMT+8, 2024-9-22 03:41 , Processed in 1.291844 second(s), Total 77, Slave 61 queries .
Powered by 电子发烧友网
© 2015 bbs.elecfans.com
关注我们的微信
下载发烧友APP
电子发烧友观察
版权所有 © 湖南华秋数字科技有限公司
电子发烧友 (电路图) 湘公网安备 43011202000918 号 电信与信息服务业务经营许可证:合字B2-20210191 工商网监 湘ICP备2023018690号