Save as .pdf in two different places

[bluesurger]

hello,

i need your help. i have a macro code which save the open Excelfile as .pdf in the same folder as the Excelfile. This is fine.
This is also the folder 1 in which the macro should save the .pdf.

Please Login or Register  to view this content.

But how is it possible to save the file also at the folder "C:\output" with the name of the "excelfile.pdf"

thank you

[Sean Thomas]

Please Login or Register  to view this content.

[bluesurger]

hello,

sorry this is not working.

Please Login or Register  to view this content.

"runtime error, not saved"

[Sean Thomas]

you need to change this to a valid file path located on your pc

Please Login or Register  to view this content.

[bluesurger]

it is working with this code

Please Login or Register  to view this content.

but now it is saved as "?????.xlsm.pdf" what i have to change to save only as "????.pdf"

Thank you

[Sean Thomas]

try

Please Login or Register  to view this content.

[bluesurger]

Thank you very much. It works.