07-14-2011, 02:19 AM
I got it, finally. Dont know why, but I changed objExcel.close to objExcel.quit and everything works.
Well almost everything.
Only the obExcel.ac tiveworkbook.save does not save the file with the latest time stamp, thus it must not be saving as I expect it to. The code does the step, bbut the time stamp does not update to the newest time.
Do I need to do something to re save the xls file with the new time stamp.
or
Can I add a count, or change the save name to add the time or env?
Well almost everything.
Only the obExcel.ac tiveworkbook.save does not save the file with the latest time stamp, thus it must not be saving as I expect it to. The code does the step, bbut the time stamp does not update to the newest time.
Do I need to do something to re save the xls file with the new time stamp.
or
Can I add a count, or change the save name to add the time or env?