Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

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.

Re: Batch printing in Excel

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

Re: Batch printing in Excel

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() )

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.