Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default create macro for save as PDF

I'm trying to create a macro to save an Excel workbook (entire workbook) as
PDF. However, when I run the macro, it defaults to the original workbook
name, not the name of the new workbook. Is there some "wildcard" I can put
in the workbook name to default to the current name when saved? Thanks for
any help.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default create macro for save as PDF

Hi cdumas

Not sure what you are looking for but I have info for 2007 here
http://www.rondebruin.nl/pdf.htm




--

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




"cdumas" wrote in message ...
I'm trying to create a macro to save an Excel workbook (entire workbook) as
PDF. However, when I run the macro, it defaults to the original workbook
name, not the name of the new workbook. Is there some "wildcard" I can put
in the workbook name to default to the current name when saved? Thanks for
any help.

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 to create a macro that sorts data when I click save? Abdul Excel Discussion (Misc queries) 3 November 10th 08 07:40 AM
Macro to Save without the Save Message Ellen G Excel Discussion (Misc queries) 4 February 23rd 07 08:52 PM
Macro to create "path" for save Chris Excel Discussion (Misc queries) 4 March 15th 06 10:38 AM
create a macro to save excel sheet Moussa Hawas Excel Worksheet Functions 1 October 16th 05 09:19 PM
How do I create a macro to Save As? Shelly9633 Excel Discussion (Misc queries) 3 December 3rd 04 05:38 PM


All times are GMT +1. The time now is 11:12 AM.

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

About Us

"It's about Microsoft Excel"