Tried to record macro for this with little luck, is this possible?. All I want is a command button to open the excel print dialog and have it set to save as PDF. Can I name the workbook by
value in A1?. Used CutePdf before but want to change to office PDF.
Thanks Z
Last edited by zplugger; 12-21-2013 at 12:58 PM.
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Well I had the PDF Converter Printer selected and recorded this:
And it worked!Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
How about a VBA Code to bring the Publish as Pdf or XPS Dialog box up ?
I can get the Dialog box to open, can I force it to be on PDF format?
Application.Dialogs(xlDialogSaveAs).Show
After many attemps I got this to work,in case someone else needs this.
Please Login or Register to view this content.
Why do you want the dialog box open? Do you want the user to change the name or specifics? Wouldn't this be more efficient to put it all in the code?
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks