Choose where to save

[marreco]

Hi.
How can I do to display the screen for the user to choose the save location, instead of the macro already forward alone?

Please Login or Register  to view this content.

I need to have the option of where to save

[AKarel]

You can change...

Please Login or Register  to view this content.

... to use a variable path, i.e. myFilePath, and set the filepath using a function like this:

Please Login or Register  to view this content.

... then something like this before you export the PDF...

Please Login or Register  to view this content.

Lots of ways to implement it. It is modified from some code I found a year or two ago so I don't take full credit. Hope it helps.

[OllieB]

Try (57 is the filetype number for PDF)

Please Login or Register  to view this content.

[marreco]

Hi.

Akarel worked thank you!
Ollieb, su code generated an error.
"The file was not saved"

[OllieB]

marreco,

this is the normal Excel file dialog for saving a workbook, except it will do save as pdf. I trust you have changed the name of the file to:

Please Login or Register  to view this content.