Can't run workbook with a macro from an 'at' command

J

John Stevens

I have an 'at' command that runs a .bat command that runs Excel (2000 and
2002 SP-1), opening a workbook with a macro. Except that Excel hangs on
opening, apparently at the macro security dialog.

The .bat file runs fine when run from a user logon (as opposed to SYSTEM),
when I have the macro security level set to LOW.

How do I set the default macro security level for Excel?

TIA
John Stevens
(e-mail address removed)
 
T

Tom Ogilvy

You can't set it with code - that would defeat the purpose.

Logon as SYSTEM and set the security to low if that is what you want. The
setting should be retained for system I would think.
 
J

Jeff Davis

Another possible solution would be to configure the 'at'
command to use a specific user account instead of SYSTEM.

If Win2k, you can do this with Control Panel, Scheduled
Tasks, Advanced Menu, and "AT Service Account".

XP is the same except the Scheduled Tasks folder is
under "Performance and Maintenance" in Control Panel.
 
J

John Stevens

I can't figure out how to log on as SYSTEM.

However, Jeff Davis' suggestion worked...

John Stevens
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Stop Command Question 4
Run code from another workbook 7
Set macro security level to 'low level' on opening a certain workbook. 2
enabling macros from command line 4
running Excel 2007 macro in Win7 3
Macro shortcuts are running macros in different open workbook 3
Run an external bat file from inside VBA 2

Top