No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
2 Posted Topics
 | 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! [code] Sub Separate() Dim s as String, sh as worksheet For Each sh In ThisWorkbook.Worksheets If … |
| | Hello everyone, I'm trying to get this Sub procedure to execute after the selected worksheet is printed. Any suggestions? [code=visualbasic] Sub Save_Printout() Dim s As String, Sh As Worksheet Set Sh = ActiveSheet Sh.Copy s = "c:\printed sheets\" & Range("M5").Value 'save location and name of worksheet ActiveWorkbook.SaveAs Filename:=s Range("A1:IV5000").Copy 'selects … |
The End.