vbscript, need help: Open Excel, run macro, save file, close Excel

need help: Open Excel, run macro, save file, close Excel

Author	Message
C.N. DiNard #1 / 2	need help: Open Excel, run macro, save file, close Excel If anyone can help me write this simple script, I would appreciate it: I would like the script to open an excel file ("books.xls"), run a macro in the excel file, save the file after the macro does its business, then exit excel. TIA Chris. cdinardo -dot- agoron -dot- com
Tue, 13 Feb 2001 03:00:00 GMT

C.N. DiNard #2 / 2	need help: Open Excel, run macro, save file, close Excel Answering my own question if some trial and error: Set objXL = WScript.CreateObject("Excel.Application") objXL.Application.Visible = True objXL.workbooks.open "c:\my documents\book.xls" objXL.Application.Run "macro1" objXL.Save objXL.Application.Quit Set objXL = Nothing Quote: >If anyone can help me write this simple script, I would appreciate it: > I would like the script to open an excel file ("books.xls"), run a macro in >the excel file, save the file after the macro does its business, then exit >excel. >TIA >Chris. >cdinardo -dot- agoron -dot- com
Thu, 15 Feb 2001 03:00:00 GMT

Page 1 of 1

[ 2 post ]