That would depend on your definition of concurrently.
If you think concurrently means that the same operations are performed at the exact same time on more than one object, I'd have to say no. Even if you were able to start concurrent sessions of Excel at the exact same time and beging execution at the exact same time, the sessions will still be given attention by your computer's processor in a serial manner making one of the sessions end before the other, etc.
If you mean you want to run the same macro on workbooks stored in different locations, I'd have to say probably yes. As long as you don't mean you also want to do something at the same time to more than one of the workbooks.
I suggest you put a new sheet called Files and in column A list out all the files you want to do the macro on (full path and name) and then run the folowing code. Substitute your macro's name in the call Macro part.
Dim tFile As String
Dim tBook As String
Dim i As Long
For i = 1 To Sheets("Files").UsedRange.Rows.Count 'Files is the sheet with the list of files
tFile = Sheets("Files").Range("A" & i).Value
If tFile <> "" Then
tBook = ActiveWorkbook.Name
Call Macro 'your macro name
Well I am working on citrix & need to update files on a remote machine. Having to open the files will take time. My question is instead of having to use the .open command is there a way of running a macro on a closed excel file.
Can I have the VBA/MAcro code on the main execl file which will list all the file paths & names of the various excel files that need to be updated and simply pressing a button will update these files even when they are closed?