Print Macro - PDF Issue
Cell D5 represents a variable number from 1-120, the input changes the data
accordingly on the whole workbook. I have input a macro to enter the number 1, print the document range A1:AB54 and then input number 2 and so on until i have 120 pages. This a frequently changing schedule and for review and distibution, would rather have a pdf doc. I changed the printer from the default to a pdf writer, when the macro runs it prints to the pdf doc but when the pdf document opens up, the macro stops after the first one, it does not go back to excel to work on number 2 etc.. Is there a way to control a macro to input the #'s and print the 120 sheets to pdf as one pdf file or at the very least 120 pdf files. Any asssitance would be greatly appreciated. |
Print Macro - PDF Issue
See this page
http://www.rondebruin.nl/print.htm#same You can change the print line (.PrintOut) to your print pdf line If you want to make one pdf you must create 120 sheets with code in the workbook and then print to pdf -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Goaliemenace" wrote in message ... Cell D5 represents a variable number from 1-120, the input changes the data accordingly on the whole workbook. I have input a macro to enter the number 1, print the document range A1:AB54 and then input number 2 and so on until i have 120 pages. This a frequently changing schedule and for review and distibution, would rather have a pdf doc. I changed the printer from the default to a pdf writer, when the macro runs it prints to the pdf doc but when the pdf document opens up, the macro stops after the first one, it does not go back to excel to work on number 2 etc.. Is there a way to control a macro to input the #'s and print the 120 sheets to pdf as one pdf file or at the very least 120 pdf files. Any asssitance would be greatly appreciated. |
All times are GMT +1. The time now is 01:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com