Copy paste range to Pdf

[besis]

Hi,

I have this code and it works for creating a pdf file of Excel with desired range with a static name that is Values
I am trying to modify this code in a way so it asks me with a messagebox (not by file explorer if that is possible) for the file to give a name before Exporting pdf to my desktop.
And it would be nice if the code also do the check if file with the given name already exists and promt to give other name.

Please Login or Register  to view this content.

Thanks in advance for any help I can get with this.
B.

[KOKOSEK]

Hi

Try:

Please Login or Register  to view this content.

[besis]

Hi,

Thanks for the code. Code works fine, but it just rewrite the existing one.
Hi can I modify the code so it will do the check if file with the given name already exists in my desktop and promt to give other name.

Many thanks.
B.

[KOKOSEK]

Please Login or Register  to view this content.

[besis]

Hi,

Thank you very much for this. Trying for 3 hours to solve this one with no help.
Your code works fine.

All the best.
B

[KOKOSEK]

You welcome.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.