I've read through the threads and tried all the suggestions that I've found but nothing seems to be working for me.
I'm using Excel 2002 SP3 and here's the issues.
From Explorer, I need to batch print about a gazillion Excel spreadsheets.
1) When it's time to close the spreadsheets, it always stops and prompts to save the changes...and I need to exit without saving. I've tried to put an Auto_close in personal.xls with the code 'ActiveWorkbook.Saved = True" but to no avail.
2) Some of these were from older versions of excel so, when it comes time to exit, I get the message that Excel always recalculates from older versions.
Since I have a gazillion files to print, that's a lot of keyboard input or mouse clicks.
Can anyone tell me what I'm doing wrong?
Thanks,
J
I'm using Excel 2002 SP3 and here's the issues.
From Explorer, I need to batch print about a gazillion Excel spreadsheets.
1) When it's time to close the spreadsheets, it always stops and prompts to save the changes...and I need to exit without saving. I've tried to put an Auto_close in personal.xls with the code 'ActiveWorkbook.Saved = True" but to no avail.
2) Some of these were from older versions of excel so, when it comes time to exit, I get the message that Excel always recalculates from older versions.
Since I have a gazillion files to print, that's a lot of keyboard input or mouse clicks.
Can anyone tell me what I'm doing wrong?
Thanks,
J