I just read my question, and I think it was a bit ambiguous. Let me restate my situation: I would like to save the worksheet after it is printed. I have the "saving part" of the code below, but I...

Hello everyone,

I'm trying to get this Sub procedure to execute after the selected worksheet is printed. Any suggestions?


Sub Save_Printout()
Dim s As String, Sh As Worksheet

Set Sh =...

I have a VB script which saves worksheets as its own workbook. How could I get it to save it as a pdf? I'm using Adobe Acrobat Professional and its Reference Libraries.

Please help!

Sub...