Hi all!
First, thanks everyone for being so helpful! I need to create a button in an excel workbook that you can click to save sheets to PDF... it selects the following sheets: "Cover Page", "Cover Letter", "Payback Summary", "Purchase Order", "Cash Flow", "Environment", "Warranty", "Terms & Conditions" and then prompts for a location to save the PDF to.
Can anyone help?
Thanks!
Mike
Last edited by FFMikeM; 02-19-2015 at 06:30 PM.
Hello,
Here's a my "goto" link when it's time to save as PDF.
This should get you started.
http://www.rondebruin.nl/win/section1.htm
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Something like this; It save in the location and name file as the workbook.
Please Login or Register to view this content.
Please click the * Add Reputation if this helps
If solved remember to mark Thread as solved
"I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks