Exporting worksheets to seperate pdf files.

**aj34321** · 10-08-2013, 01:30 AM

Dear All,

I have a excel file in which i have roughly 100 worksheets containing some data and print range is already set for each worksheet.

I have to export each worksheet file into a seperate pdf file which is a time consuimg process.

I need to write a VBA code which will iterate through worksheets and export into a seperate PDF file. PDF file name will be the worksheet name.

Experts, please advice me how to write this code..

Thanks a lot in advance.

Rgds, Anil

**Dimitrov** · 10-08-2013, 02:24 AM

Please Login or Register  to view this content.

_____________________
[1] If this reply was helpful, click the star to the left.
[2] If this reply answered your question, mark this thread as [SOLVED].