Check out this link...

http://www.excelguru.ca/node/21
--
HTH...

Jim Thomlinson


"Pritesh" wrote:

I have developed a reporting tool in excel, where I need series of worksheets
to be saved as PDF one after another through a click of button (VBA
macro-enabled).

I need VBA code to save my print-area as PDF where it only once asks "where
to save" and then saves current series of PDFs. It should take file name from
a fixed cell too.

Regards,
Pritesh