Excel command line

[Asator]

Are there any command line switches for excel that would cause it to run while suppressing the "Allow macro?" diaglog box (defaulting to No), open and print specified file, and close?

I'm currently using shellexecute to print excel files, but it requires user interaction for workbooks that have macros. I'd like to get rid of that prompt (obviously without lowering their security settings).

Any ideas?

 

[Asator]

Bump!

 

[shg]

I think (not sure) that the /safemode switch will prevent macros from running.

If that doesn't work, you could instead open the workbook in VBA after disabling events to prevent macros from running.

If you need events enabled when the code runs, you can open the workbook in a separate instance of Excel after setting Application.AutomationSecurity to msoAutomationSecurityForceDisable

 

[Asator]

Well... hmm.

I'm calling this from Outlook. That'll be interesting.

 

[Asator]

This was a lot easier than I expected. Only took 4 lines of code.

I already have an excel instance open from my VBA, so I just turned off security in that instance, opened the workbook, printed, closed it.

For those curious:

Dim xlApp As Object
 
...
 
'Create ActiveX connection to Excel, turn off security warnings (block macros)
Set xlApp = CreateObject("Excel.Application")
xlApp.AutomationSecurity = msoAutomationSecurityForceDisable
 
...
 
Case ".xls", ".xlsx", ".xlsm", ".xlsb"
    xlApp.workbooks.Open (rtFolder & sender_folder & "\" & dStr & "\" & AttFileSaveName)
    xlApp.workbooks(AttFileSaveName).PrintOut
    xlApp.workbooks(AttFileSaveName).Close False
    pCount = pCount + 1