Save as PDF

[TimlmiT]

Hello,

I am looking for some help with a code for a macro that:

Gets a file name from cell (AP3)
uses that name to save or export the file to a PDF.

I have a macro that can do the above in the current directory. However, I am not knowledgeable enough to figure out how allow the user the ability to select the directory path to save the file.

I am sure this has been done, but I am having difficulties in locating it in the archives.


Thanks in Advance.
Tim

[Solus Rankin]

Perhaps if you posted the code you have we could make amendments.

No reason to re-invent the wheel.

[TimlmiT]

Below is a code I am using to run a save as .xlsm file. it allows the user to change the directory and it work great. However, I don't know how to change it so that it saves the file as a PDF.

Please Login or Register  to view this content.

Based on help from Excel forum, I have the following code that saves the file as a PDF, but only in the current working directory.

Please Login or Register  to view this content.

I hope to combine the two to make it work like the first code.

TIA.

[Solus Rankin]

Maybe

Please Login or Register  to view this content.

e/ This code doesn't have any error handling so you'll probably get a run-time error if cancel is pressed on the saveas dialog box.

[TimlmiT]

Awesome. Works great..

Thank you very much!!!