insanity2k4
2/4/2009 4:45:00 PM
Ugh, I just answered my own question accidentally. Apparently I got
sidetracked or distracted. At the end of the script I was missing
this:
-----/
' Save the spreadsheet and close the workbook.
objExcel.ActiveWorkbook.SaveAs strExcelPath
objExcel.ActiveWorkbook.Close
' Quit Excel.
objExcel.Application.Quit
Wscript.Echo "Done"
-----/
Tom, thanks for your help. Now I'll work on using the subroutine you
provided.