I am looking for a way to schedule a task which will open a specified Excel workbook, then close Excel. The workbook that I want to open has a macro inside the WorkBook_Open() function which causes the contents of one of the Worksheets to be saved to a text file.
The WorkBook contains Jet Reports coding. I can schedule a task to run the report, but using, say, the Before_Close() function does not work. I want to have this work under Windows Server 2008 using Excel 2007. The Before_Close function worked under Windows Server 2003/Excel 2033, but it does not work under W2008/E2007, so I am looking for another method to cause the saving of a Worksheet via a scheduled task.
I have tried this using a batch file, but have had no luck so far.