S Shay A Member Jul 2, 2016 #1 Hi, Is there a way to use VBA coding to print all files in a certain folder? And by that I mean All of the sheets in each Workbook. Thanks, Shay
Hi, Is there a way to use VBA coding to print all files in a certain folder? And by that I mean All of the sheets in each Workbook. Thanks, Shay
mohadin Active Member Jul 2, 2016 #2 hi you can build up on this attachment regards Attachments printout.xlsm 20.4 KB · Views: 7
S Shay A Member Jul 2, 2016 #3 Hi, I forgot to mention that it would be best to print all of the workbooks without having to go into each of thembqnd print it out. TY
Hi, I forgot to mention that it would be best to print all of the workbooks without having to go into each of thembqnd print it out. TY
mohadin Active Member Jul 2, 2016 #4 Option Explicit Sub printout() Dim sh_name As Variant Dim i As Integer Dim sh As Worksheet For i = 1 To Sheets.Count Sheets(i).printout Next i End Sub
Option Explicit Sub printout() Dim sh_name As Variant Dim i As Integer Dim sh As Worksheet For i = 1 To Sheets.Count Sheets(i).printout Next i End Sub
mohadin Active Member Jul 2, 2016 #6 it is to loop through the active WB and print all sheets you will need to develop it to your requirement good luck
it is to loop through the active WB and print all sheets you will need to develop it to your requirement good luck
