How to use a macro to save worksheet as pdf to current folder
Hi guys,
This is my first time in this forum. I run a macro that saves a sheet to my desktop as pdf. I want multiple users to have a copy of this excel document and be able to save as PDF to whatever folder they have the excel saved in. Not sure how to do that.
I included the macro below.
Thanks,
Lriver2
Please Login or Register to view this content.
Last edited by lriver2; 02-13-2013 at 03:14 PM.
Please be advised that whenever you post code you will have to use the CODE tags as per the forum rules. Please edit your post, select the code and click on the # button.
The answer to your question:
Please Login or Register to view this content.
If you like my contribution click the star icon!
thanks for the help. I edited my post. One more question. I want the title of the pdf to change as the user edits the name of the excel document. Currently, I can have a file named 'AnyData.xlsm' but the pdf version will still remain as 'Master Sheet.pdf'.
Any idea how to work around this?
Thanks,
Lriver2
I am not sure there is such a thing as a PDF title. I think what you are seeing is the name of the PDF object assigned when saving
Ok, misunderstood your request
Try
Please Login or Register to view this content.
works great! thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks