Scheduled Task Opens Excel in Safe Mode

[mosh]

Hey Guys,

I have tried to automate a running of a report in Excel which runs fine when I open it normally. All security settings have been set to low and the macros within run fine. I've now tried to schedule it via MS Scheduler but it seems to open the workbook in safe mode thus not allowing it to run the automatic macros i've created.

For Run I have:

"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" -sysin "xxxx\scheduled.xlsm"

For Start In I have:

"C:\Program Files\Microsoft Office\Office12"

Can anyone help as to how it can open Excel without it being in safe mode?

Many thanks

 

[mosh]

anyone?

Thanks

 

[RoryA]

I suspect removing the -sysin would do it - what is that supposed to do? (it doesn't tally with any startup switch I know of, although it's close enough to /s for me to think that's why it's running in safe mode)

 

[mosh]

Thank you very much! I've been looking at this for a while. Can you explain why people use -sysin?