Excel VBA code to convert and save Active sheets as PDF

**mchilapur** · 04-29-2015, 07:06 AM

Dear all,
I need code to convert active sheet into pdf format with file name as "Rename_This file" and want it to be saved into 'D:Pdf sheets\backup\' every time.

But this code must prompt me to save the pdf with default location at mentioned above.

Plz help.

**LokeshKumar** · 04-29-2015, 07:28 AM

It is always helpful for others to reply your query faster if you upload the workbook....

**mchilapur** · 04-29-2015, 07:49 AM

I know, but I felt my query doesnt require any workbook. It's pretty much straight forward.
Sorry.

**TMS** · 04-29-2015, 07:55 AM

I think LokeshKumar's request is quite reasonable.

You want someone to create folders in order to be able to test a solution, create some arbitrary test data, and then give you a macro to do this for you?

And your contribution to the process is ... what, exactly? Ask a question? No data, no draft code, not a problem to fix, ... just, make this for me?

I suggest that you record a macro to do exactly what you have described. If necessary, view the recorded code and see if it needs editing.

Then, if you have a problem, ask for help.

Regards, TMS