I remember skimming by that thread. Thanks for the solution (I'll speak for the
OP!).
Tom Ogilvy wrote:
Dave, I think he has tried that and is making reference to this article:
http://support.microsoft.com/default...b;en-us;211626
XL2000: EnableEvents Property Does Not Work in Automation Server
So the solution for that case is a macro run from within Excel that disables
events. How that is implemented by the OP is their decision.
--
Regards,
Tom Ogilvy
"Dave Peterson" wrote in message
...
Can you open the workbooks after you disable events:
dim wkbk as workbook
application.enableevents = false
set wkbk = workbooks.open(...)
application.enableevents = true
And if you do anything to the workbook, turn off events before you do it.
Wouldn't that be the equivalent of disabling macros???
Remy wrote:
Hey
Is there a way to switch off macros when you open a workbook with Excel
2000 via Automation?
I know there is the
excelApp.AutomationSecurity =
soAutomationSecurity.msoAutomationSecurityForceDis able;
in Excel 2003, but that is not around for 2000 yet.
Also, setting
EnableEvents = false
is not working either. Seems to be a bug according to MS.
Thanks
Remy Blaettler
www.collaboral.com
--
Dave Peterson
--
Dave Peterson