Menu

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

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming

John Stevens John Stevens is offline

John Stevens is offline

external usenet poster

Posts: 3

Default

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

Thanks, that worked fine...

John Stevens

"Jeff Davis" wrote in message
...
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.

-----Original Message-----
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.

--
Regards,
Tom Ogilvy

"John Stevens" wrote in message
. ..
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

.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use Macro To Change Which Macro Assigned To Command Button	CVinje	Excel Discussion (Misc queries)	0	May 25th 10 09:55 PM
this command is not available in a shared workbook	wgallipeau	Excel Worksheet Functions	0	August 23rd 06 07:48 PM
Assign macro name to menu command w/o using workbook name	Blight_Pete	Excel Discussion (Misc queries)	0	August 3rd 06 10:48 PM
VBA Code to kick off macro when workbook command to close is initi	zulfer7	Excel Discussion (Misc queries)	2	June 23rd 06 08:04 PM
Disable a command from with in a workbook	Tony Pizza	Excel Programming	0	July 22nd 03 12:42 AM

All times are GMT +1. The time now is 11:47 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement