The Andrew N. Wiggins Consultancy

Contact me at webmaster@anw.biz

Experimental Site

 

This site designed by Byg Software Ltd

 

The ANW.BIZ Home Page
Up

VBS Script

Put this script into a VBS file (using a .VBS extention).
It will create a new Excel object (session), open the file, show the session, run the macro, then close the session.
This will leave any pre-existing Excel session untouched.

Set xlObj = CreateObject("Excel.application")
xlObj.Workbooks.Open "c:\temp\RunTest.xls"
xlObj.Visible = True
xlObj.Run "TestRunX"
xlObj.Quit
 
 

Published: 31 January 2004
Last edited: 19 May 2008 16:41