Hi,
I have the attached macro that saves the selected cells as pdf. The pdf is saved to same workbook path but I want to give the users the option to select their own folder and own name. Can someone please help?
Thanks,
Hi,
I have the attached macro that saves the selected cells as pdf. The pdf is saved to same workbook path but I want to give the users the option to select their own folder and own name. Can someone please help?
Thanks,
Don't forget to specify the filename.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank you Bakerman2. Instead of putting the name of the file in the code, can you please modify so the user put their own name?
Here you go.
Please Login or Register to view this content.
Awesome Bakerman2 than you so much!
Glad to help and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks