Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 50
Default macro to convert excel to PDF

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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default macro to convert excel to PDF

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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I use macro in Excel 2007 to convert to and email PDF file rick5555 Excel Worksheet Functions 9 November 15th 13 04:39 PM
writing macro to convert excel to pdf matt Excel Discussion (Misc queries) 5 February 23rd 07 12:50 AM
Excel 2007 Problems; in writing macro and convert text to colums bezl Excel Discussion (Misc queries) 2 December 22nd 06 11:20 AM
Excel 2007 Problems; in wrinting a macro and convert text bezl Excel Discussion (Misc queries) 1 December 22nd 06 10:59 AM
Macro or VBA to convert Excel sheet to JPEG, DICOM or TIFF formats DORI Excel Worksheet Functions 2 November 24th 05 08:42 PM


All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"