Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button to print XLS file as PDF
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To Disable The File, Print... And The Print Button Functions | Excel Programming | |||
print 2 worksheets from print button? | Excel Programming | |||
print button macro & specific tabs to print | Excel Worksheet Functions | |||
Create command button to print multiple worksheets in a excel file | Excel Discussion (Misc queries) | |||
overriding the print button and File/Print | Excel Programming |