Excel - VBA code for "Save as PDF"

Asked By Pritesh on 26-Feb-10 03:57 AM
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




Jim Thomlinson replied to Pritesh on 26-Feb-10 09:41 AM
Check out this link...

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

Jim Thomlinson