I'm using vbscript to put together a script that automates a horribly manual process for generating daily sales reports. It handles everything from downloading the data from our ERP system, dumping it to Excel, formatting it, saving the file to a central server, and emailing it to selected individuals.
I got the script running perfectly, with the exception of excel.exe not closing when the script is finished running.
I have "option explicit" turned on, and I doublechecked to make sure that every object I created is gracefully set to nothing before the objXL.quit command.
I am not sure why this is happening ... I've googled all over and cant find a solution for vbscript/WSH (can only find VB6 & VB.Net). I am not sure where else to look.
I'd post all my code in here but the problem is that my code is approx 875 lines long (30K in size) ... I am not sure what portions to post if any.
I have another simpler report generator script that handles some smaller reports that was the base for this script I am having trouble with. The simpler version closes Excel fine, and it uses the exact same object creation and object destruction code as the complex version.
Anyone have any ideas or common things I could have overlooked that would cause this?
Any help is created appreciated.
Matt Laski
Web & Systems Support
Pulsafeeder Inc.
I got the script running perfectly, with the exception of excel.exe not closing when the script is finished running.
I have "option explicit" turned on, and I doublechecked to make sure that every object I created is gracefully set to nothing before the objXL.quit command.
I am not sure why this is happening ... I've googled all over and cant find a solution for vbscript/WSH (can only find VB6 & VB.Net). I am not sure where else to look.
I'd post all my code in here but the problem is that my code is approx 875 lines long (30K in size) ... I am not sure what portions to post if any.
I have another simpler report generator script that handles some smaller reports that was the base for this script I am having trouble with. The simpler version closes Excel fine, and it uses the exact same object creation and object destruction code as the complex version.
Anyone have any ideas or common things I could have overlooked that would cause this?
Any help is created appreciated.
Matt Laski
Web & Systems Support
Pulsafeeder Inc.