Execute excel macro without opening file

[EricBonsu]

Anyone know if its possible to execute an excel macro using vbs without opening the excel file? I know how to execute the macro by opening the file first.

 

[markdmac]

Without Excel running, how would it be able to access the properties of a spreadsheet?

It is possible to script all features of Excel without using a macro.

What are you trying to do with Excel?

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[EricBonsu]

Thanks for the reply Mark. I just wanted to know if there was a way to do it without having a spreadsheet open and close, its not really a problem if it does cos its only for a second.