Batch printing in Excel
Posted by Rebecca A. Pakish on February 23, 2001 10:17 AM
I am trying to print several workbooks at once. It should be a no brainer. The problem is that one field is a date field that incorporates the current date. This causes the batch printing to stop after each workbook is printed to ask if I want to save the changes to this workbook before closing. (Thus eliminating the efficiency of batch printing!) I cannot find anywhere to turn off this prompt. Am I missing something or is there a better way to do this?
Please help.
Posted by Dave Hawley on February 23, 2001 10:32 AM
Rebecca, Place:
ActiveWorkbook.Saved = True
In your code. This will make Excel think the workbook has been saved.
Dave
OzGrid Business Applications
Posted by Rebecca on February 23, 2001 11:24 AM
I tried this...but it didn't work. When the print function I'm using in the Open File Tools menu to print multiple workbooks opens each file to print, it must reset that code, because it still prompts me to save due to changes. (Which I assume is because it's actively "resetting" the date to today() )
