Excel 2010 - Select Save as type: PDF

[excelenergy]

Hello,

I found allot of ways to do this online, but not quite what Im looking for....I have a userform with a save as pdf button....Ideally when the user clicks the button, Id like it to automatically save as a pdf and also Id like it to print portrait as well....I was using this code:

but it didn't something a little different than what I want:
http://www.mrexcel.com/forum/excel-q...me-path-2.html

Here is my currect code for the save as pdf button........Has anyone ever done this before, and have any insight as to how to do it:
Regular Module:

Please Login or Register  to view this content.

In the Command button on the userform:

Please Login or Register  to view this content.

[excelenergy]

Hello,

So this works, top of the userform, only thing now is it prompts you to delete the screen capture from the worksheet, Id like to stop that prompt and have it just auto-trigger the delete button from the prompt. Is there a way to do that?

Thanks again for the help!

Please Login or Register  to view this content.

Using this for the print button:

Please Login or Register  to view this content.

[excelenergy]

I also found this code, but I cant really understand it, but what it does is create another userform - thats a PDF Viewer, then I assume it triggers a print, but I dont completely understand it, this is the one Im trying to make work for me though...Oh I guess I should indicate my error...The error I get when executing this code is:

"Compiler error - User defined type not defined" and its highlighting the section "Dim PDForm As AcroPDF" - Im also referencing all the correct libraries in VBE.

...At the top of your userform its this code:

Please Login or Register  to view this content.

Then on your command button code that triggers the 'save as pdf'

Please Login or Register  to view this content.