Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel sheets to PDF
Here is all the code. I realized you could not see the code after I changed it. Sorry Sub makepdf() ' ' makepdf Macro ' Macro recorded 7/2/2007 by HP Authorized Customer 'Using Bits, Pieces and tips from all across the forum, this is the 'simple code that finally did it for me : 'SET DEFAULT...- Donatumw
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel sheets to PDF
Sub makepdf() ' ' makepdf Macro ' Macro recorded 7/2/2007 by HP Authorized Customer 'Using Bits, Pieces and tips from all across the forum, this is the 'simple code that finally did it for me : 'SET DEFAULT PRINTER TO ADOBE FOR PDF REPORTS Set Application.Printer = Application.Printers("Adobe...- Donatumw
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel sheets to PDF
I have an Excel file with 5 sheets. Trying to get all 5 sheets to go to PDF. It seems that only one sheet will go. I read where this is still not possible. I have Acrobat 7 professional. I tried the vba code here but got errors...- Donatumw
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
