View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Denis[_4_] Denis[_4_] is offline
external usenet poster
 
Posts: 38
Default enabling macros from command line

I need to automate some Excel processing via macros so that a job can
just be scheduled to run without any user involvement. For this to
work, macros have to be enabled. Unfortunately, I know of only one
way to do this that doesn't involve interaction from the user -
setting the security level to low.

Is there any other way around this? Ideally, there would be a command
line option that would enable macros but I haven't found anything.
Setting the security level to low will obviously work but it's not a
good solution. Any other possibility?

Denis