PC Review


Reply
Thread Tools Rate Thread

Button to print XLS file as PDF

 
 
johan
Guest
Posts: n/a
 
      18th Jun 2010
Hello,

Can somebody help me out.

Within a xls file I want to create a button with a macro which will
print the printarea as a acrobat pdf file with the filename as
registered in datafield A2.
If this is, for example "testtest" than after push the button the
macro should give the printpreview as pdf file with the name
testtest.pdf

I also like to have a macro which shows me the ;save as; box with file
name mentioned the same as above. The ;save as; box shows then
filename testtest.xls

Somebody knows the solution........ thanks.

regards,
Johan.





 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How To Disable The File, Print... And The Print Button Functions Andy Microsoft Excel Programming 5 12th Jul 2008 01:04 AM
Re: Adding a button to print a file =?Utf-8?B?TWFyayBFLg==?= Microsoft Frontpage 0 11th Jul 2007 11:36 PM
overriding the print button and File/Print Pablo Microsoft Excel Programming 3 11th Sep 2003 07:07 PM
Re: print button under file menu greyed out in Excel Milo Microsoft Excel Misc 0 11th Sep 2003 12:16 PM
overriding the print button and File/Print Pablo Microsoft Excel Misc 1 10th Sep 2003 10:03 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:45 PM.