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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.