Macro - Print to PDF issue

Hi

I have writte a simple macro to print to PDF using Adobe PDF however I am missing the option to ask when you want to save the file.

Would you know what I need to add to promte to where I can save and open it after it has been saved? I have predetermind the file name and I thought that may cause the issue

Please Login or Register  to view this content.

In addition once the file is saved Adobe cannot reopen the as it has some deconding error, I really do not know what I would need to add.


I really appreciate any kind of help

Thank you in advance

Are you using xl'2003 like your profile indicates?

Excel 2003 cannot create pdfs directly, you need pdf software as well