View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.