Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable macro in excel automation with VC++/Win2k
Hi,
I have a problem trying to automate an excel file from Visual C++ in Win2k. The installed version of Excel is 2000. I need to disable all macros before loading. Could you help me? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable macro in excel automation with VC++/Win2k
You can disable events with
Application.EnableEvents = False That is the VBA way - you would have to adapt it to C++ -- Regards, Tom Ogilvy "mbozzaotre" wrote in message oups.com... Hi, I have a problem trying to automate an excel file from Visual C++ in Win2k. The installed version of Excel is 2000. I need to disable all macros before loading. Could you help me? Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable macro in excel automation with VC++/Win2k
I tried in this way, but it had no effect in my application :-(
Finding another solution, i noticed that the macro secutity level option setted to high disable the macro execution loading the file by excel application. Is it also possible to set the macro security level in automation mode? Tom Ogilvy ha scritto: You can disable events with Application.EnableEvents = False That is the VBA way - you would have to adapt it to C++ -- Regards, Tom Ogilvy "mbozzaotre" wrote in message oups.com... Hi, I have a problem trying to automate an excel file from Visual C++ in Win2k. The installed version of Excel is 2000. I need to disable all macros before loading. Could you help me? Thank you. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable macro in excel automation with VC++/Win2k
I believe it is a registry setting, so you could change the registry setting
before starting excel. You might search this group for the key/bits you have to set. I know it has been posted for xl97, but don't know if it has (or is the same) for xl2000 or later. -- Regards, Tom Ogilvy "mbozzaotre" wrote in message oups.com... I tried in this way, but it had no effect in my application :-( Finding another solution, i noticed that the macro secutity level option setted to high disable the macro execution loading the file by excel application. Is it also possible to set the macro security level in automation mode? Tom Ogilvy ha scritto: You can disable events with Application.EnableEvents = False That is the VBA way - you would have to adapt it to C++ -- Regards, Tom Ogilvy "mbozzaotre" wrote in message oups.com... Hi, I have a problem trying to automate an excel file from Visual C++ in Win2k. The installed version of Excel is 2000. I need to disable all macros before loading. Could you help me? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with excel macro - getting automation error | Charts and Charting in Excel | |||
VB6 Excel 97 code no longer works if Win2K SP3/4 applied. | Excel Programming | |||
How to create a VB macro in Excel from Automation... | Excel Programming | |||
Macro 'Automation error' with ChemOffice Excel macro | Excel Programming | |||
Disable macro through automation | Excel Programming |