Macro to pull in the worsheet name to save it as a PDF.

[aadeshgandhi]

Hello,
When I run the macro I would it to save it to a PDF and also choose the name for a PDF based on the worsheet name. I have the macro setup in which its prints the selected sheet but I have to manually enter the name for each PDF. How to write to code so that the name = worksheet name? Below is the code.
Printer can be either Adobe PDF or CutePDF.

Please Login or Register  to view this content.

Thanks,
Aadesh Gandhi

[SEOSEO.dk]

I do NOT have the answer - but exactly the same issue. Look forward to see the administrators answer! Thank you aadeshgandhi to post this issue.

[aadeshgandhi]

I do NOT have the answer - but exactly the same issue. Look forward to see the administrators answer! Thank you aadeshgandhi to post this issue.

SEOSEO,
I was able to get two ways for it to work,
1) This will save the PDF in the same directory as the worksheet.

Please Login or Register  to view this content.

2) This will save the PDF to the desktop.

Please Login or Register  to view this content.

I hope this works for you.



Thanks,
Aadesh Gandhi