Running Macros on multiple files

[cturner1975]

Hi,

I have a large number of excel files that I need to run certain macros everyday. I have all the macros save on one excel file. Is there a way to select all the excel files that I want to run the macros, rather than me having to open each excel file and run one by one? This will be a big time saver for me.

Can someone please help me with this? Thanks!

Here is one of the marco that I use regularly:

Sub Prop_AB()
Dim LR As Long, cell As Range
LR = Range("A" & Rows.Count).End(xlUp).Row
For Each cell In Range("A1:B" & LR)
cell.Value = StrConv(cell.Value, vbProperCase)
Next cell
End Sub

 

[VoG]

You will need to open each file then run the code. Take a look at Dir inthe VBA help.

 

[Tuelor]

If you put all the filepaths in a list, you could loop through the list calling the approppriate macros. For example if you put 10 filepaths in column A

Dim iCount as Integer
Dim sApp As String
Dim sTarget As String
sApp = ActiveWorkbook.Name
 
For iCount = 1 To 10
    Workbooks.Open Workbooks(sApp).Sheets(1).Cells(iCount, 1).Value
    sTarget = ActiveWorkbook.Name
 
    Call Prop_AB
 
    Workbooks(sTarget).Close savechanges:=True
Next iCount
Workbooks(sApp).Activate

 

[scooper2000]

1