View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default macro to convert excel to PDF

I found this very useful

http://www.rondebruin.nl/pdf.htm

HTH,
Barb Reinhardt

"Stefi" wrote:

Maybe you can use this freeware, it acts as a printer:
http://sourceforge.net/projects/pdfcreator/

Regards,
Stefi

€žEricBB€ť ezt Ă*rta:

I'm trying to automate the process to convert 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 Excelsheet and create another report, save the new one as
another PDF file. Excel should continue the procedure until the macro tells
Excel to stop).

Any suggestion will be highly appreciated.