excute uniform macro on several sheets at once

[abdul hafeel]

I need to run a uniform macro on several stored in different folders cocurrently. Can this be done

Thanks in advance

 

[Dufus]

abdul hafeel,

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.

Dufus

 

[abdul hafeel]

Hi Dufus

What I meant was to run the same macro of different closed worksheet, one after the other. So I agree It's not a concurrent operation. Sorry for the confusion. Could you pls help on this.

Thanks in advance.
Cheers

 

[gaj104]

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.

Sub RunAll()

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

            Workbooks.Open(tFile).Activate
            tBook = ActiveWorkbook.Name
            Call Macro 'your macro name
            Workbooks(tBook).Close SaveChanges:=True
            
        End If

Next i

End Sub

Hope it helps

 

[abdul hafeel]

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?

Cheers