Bypass addins when shelling excel

[Jaafar Tribak]

As opposed to the New keyword or the CreateObject function, the Shell command launches a new instance of excel along with any addins.

How can I avoid loading Addins when shelling excel ? The /s switch does prevent addins from loading but it also disables all Macros in excel 2007.

thanks.

 

[Jaafar Tribak]

Anybody ?

 

[AlphaFrog]

Try using the /automation switch instead of the /s switch.

Shell Path & "\EXCEL.EXE /automation"

 

[Jaafar Tribak]

Try using the /automation switch instead of the /s switch.

Shell Path & "\EXCEL.EXE /automation"

Nice !

Where did you find out about that switch ? I looked everywhere but never saw that one !

Thanks very much.

 

[AlphaFrog]

I googled "excel /s switch" and clicked on the 1st link

http://www.tek-tips.com/faqs.cfm?fid=1371

 

[Jaafar Tribak]

It is definitely not where it is supposed to be ie: on the MS site !

 

[RoryA]

MSKB article here.

 

[Jaafar Tribak]

MSKB article here.

Me think my searching abilities suck