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.

0
Utf
12/9/2009 5:52:01 PM
excel.worksheet.functions 4936 articles. 2 followers. Follow

1 Replies
1037 Views

Similar Articles

[PageSpeed] 3

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" <Goaliemenace@discussions.microsoft.com> wrote in message news:5D5A1408-1595-4013-9E5F-6E0C1D615547@microsoft.com...
> 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.
>
0
Ron
12/9/2009 6:24:22 PM
Reply:

Similar Artilces: