I am currently using the below code that I just repeat over and over just replacing the wb open file name. I have tried several ways to write an array 1) to shorten code and 2) when I need to add/remove a workbook that is being opened it is easier, but have been unsuccessful. Below is the code that I am using, can someone combine it to an array for me....
[vba]
Dim wb As Workbook
Set wb = Workbooks.Open(Filename:="C:\Richard\Daily\Friday\Friday_Reports.xls"
With ActiveWorkbook
.SaveAs Filename:="C:\Master_Reports\Friday\" & ActiveWorkbook.Name & "_" & VBA.Format(Date, "mmddyyyy") & ".xls"
Run "PrintToPDF_MultiSheetToOne_Early"
.Close& ".xls"
End With
Set wb = Workbooks.Open(Filename:="C:\Mark\Daily\Friday\Friday_Reports.xls")
Run "RefreshOnOpen"
With ActiveWorkbook
.SaveAs Filename:="C:\Master_Reports\Friday\" & ActiveWorkbook.Name & VBA.Format(Date, "mmddyyyy") & ".xls"
Run "PrintToPDF_MultiSheetToOne_Early"
.Close& ".xls"
End With
[/vba]