Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing mulitple times to adobe
Hello experts,
I'm trying to run a loop/series of print cycles and have the pdf saved to the hard drive of the user (path is typed out in cell J5 as you will see inthe code below..) The code runs nicely and creates the .pdf files but you can't open them because it says they are corrupted. Can anyone shed some light on this? Code below: Private Sub Print_Click() Dim i As Integer 'partner number For i = 1 To Range("J6").Value Range("B4").Value = i ActiveWindow.SelectedSheets.PrintOut Copies:=1, Printtofile:=True, Prtofilename:=Range("J5").Value Next i End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adobe inserting into Excel causing the adobe file to be low dpi | Excel Discussion (Misc queries) | |||
Adobe Acrobat | Excel Discussion (Misc queries) | |||
Adobe 6.0 Standard | Excel Discussion (Misc queries) | |||
how to re install Adobe Acrobat in Excel? The adobe Acrobat work. | Excel Discussion (Misc queries) | |||
Adobe PDF | Excel Discussion (Misc queries) |