I'm fairly new to Excel programming. I'm trying to automate the process
to covert reports generated by an Excel macro to PDF files (one report
has to be saved as a PDF file, then the macro will clean up the Excel
sheet and create another report, save the new one as another PDF file.
Excel should continue the procedure until the macro tells Excel to
stop).

I tried the "record macro" function to record the process but no VB
code was recorded for the procedure to convert an Excel range to a PDF
file. I have asked all my friends for help but nobody knows what VB
code could tell Excel to do the job.

Any suggestion will be highly appreciated.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Excel has no built in capability to do it. The usual method is to use the
pdfwriter print driver from Adobe Acrobat. Do you have Adobe Acrobat - the
whole product, not just the reader?

You can also look for third party solutions

http://www.pdfplanet.com

--
regards,
Tom Ogilvy


wayne wrote in message
...
I'm fairly new to Excel programming. I'm trying to automate the process
to covert reports generated by an Excel macro to PDF files (one report
has to be saved as a PDF file, then the macro will clean up the Excel
sheet and create another report, save the new one as another PDF file.
Excel should continue the procedure until the macro tells Excel to
stop).

I tried the "record macro" function to record the process but no VB
code was recorded for the procedure to convert an Excel range to a PDF
file. I have asked all my friends for help but nobody knows what VB
code could tell Excel to do the job.

Any suggestion will be highly appreciated.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/