Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 163
Default Macro to save the excel sheet to PDF

Hi, can someone help me, I am trying to create a macro for when pressed save
the entire workbook to PDF.

Is this possible? Please Help.

Neil.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default Macro to save the excel sheet to PDF

Neil,

I have 'heard' it's supported in E2007 but not in earlier versions. I've
used the free utility below.

http://www.primopdf.com/


Mike


"Neil Holden" wrote:

Hi, can someone help me, I am trying to create a macro for when pressed save
the entire workbook to PDF.

Is this possible? Please Help.

Neil.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default Macro to save the excel sheet to PDF

Take a look at Ron DeBruin's site. He's got some good info there.

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

HTH,
Barb Reinhardt

"Neil Holden" wrote:

Hi, can someone help me, I am trying to create a macro for when pressed save
the entire workbook to PDF.

Is this possible? Please Help.

Neil.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Macro to save the excel sheet to PDF

FYI

I update the page yesterday with a new argument if you want to use a fixed file name.

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Barb Reinhardt" wrote in message
...
Take a look at Ron DeBruin's site. He's got some good info there.

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

HTH,
Barb Reinhardt

"Neil Holden" wrote:

Hi, can someone help me, I am trying to create a macro for when pressed save
the entire workbook to PDF.

Is this possible? Please Help.

Neil.


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,939
Default Macro to save the excel sheet to PDF

Check out this link...

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

Jim Thomlinson


"Neil Holden" wrote:

Hi, can someone help me, I am trying to create a macro for when pressed save
the entire workbook to PDF.

Is this possible? Please Help.

Neil.



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
macro to save current excel sheet only without losing formatting Genesis Excel Programming 2 June 22nd 07 04:31 PM
Save Excel sheet as webpage with macro Gunnar Lysaker Excel Programming 1 May 10th 07 02:42 PM
Macro to save excel sheet in a workbook [email protected] Excel Discussion (Misc queries) 1 March 7th 07 02:37 PM
create a macro to save excel sheet Moussa Hawas Excel Worksheet Functions 1 October 16th 05 09:19 PM
Can I save my Excel sheet with Macro as webpage? It seems the Mac. John Excel Programming 1 February 4th 05 03:50 PM


All times are GMT +1. The time now is 08:34 AM.

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"