If I am running a macro from a certain workbook in which I have a list of other Excel workbooks (including filepath), is there are way to run a macro to be executed for all of the listed workbooks? An example list would be:
Let us say that this list will vary in length, and will always be in Sheet1, column A of the macro-bearing workbook. I want a macro to call the process to be executed for each of these files. Let's call this other macro/process "FileProcess."
I have a macro that will loop through all files in a folder and run the FileProcess macro, but that is not what I want, because I want flexibility about what files to process, and from what location:
Public Sub Loop()
Dim Filename As String
Dim SourceWorkbook As Workbook
Dim SourceWorksheet As Worksheet
'Change below to suit
Const Folder = "C:\Files"
Filename = Dir(Folder & "\*.XLSX")
Do While Filename <> ""
Workbooks.Open Folder & "\" & Filename