macro to save sheet as pdf on desktop regardless of user

[skf786]

Hi,

Want to save active sheet only, want to save as PDF and would like the file to open in pdf once it is saved, on the desktop, regardless of user. Thanks for your help in advance!!

Ive got very very limited know how of <acronym title="visual basic for applications">VBA</acronym>!

 

[GTO]

Reference the email thru Outlook, take a look at:
https://msdn.microsoft.com/en-us/library/ee834871(office.11).aspx
https://msdn.microsoft.com/en-us/library/ee834871(v=office.12).aspx

Hope that helps,

Mark

 

[skf786]

Thanks so much!

 

[GTO]

You are most welcome