Hi to all,
I need your Help.
I created a command button on my excel file and i want to save the active sheet as pdf on desktop when i click on it.
Thank you.
Hi to all,
I need your Help.
I created a command button on my excel file and i want to save the active sheet as pdf on desktop when i click on it.
Thank you.
You can do by record macro
Please Login or Register to view this content.
"Presh Star Who has help you *For Add Reputation!! And mark case as Solve"
I have no idea about VBA, I will only write this code?
Into sheet code:
into module:Please Login or Register to view this content.
Check attached file.Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Try
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Private sub CommandButton1()
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
fileName:=Createobject("WScript.Shell").SpecialFolders("Desktop") & "\MyPdf.pdf"
End sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks