Brainstorming a way to run a Macro through all excel files in a folder

[Wamhoi]

I want a run a Macro that opens each workbook(with different wk Names) in a designated share folder. Filter the data and copy the information to a Master workbook that contains the macro. I'm not sure where to begin coding. Does anyone know a site I can begin to learn or do you have a basic template you've worked on in the past that can help me.

Thanks,

 

[VoG]

Take a look at Dir.

 

[Norie]

Not sure what you mean by a 'share' folder but there are various ways you could loop through all the files in a folder.

Here's a simple example to get all the files with an extension that includes 'xl' and put them on a worksheet.

Option Explicit
 
Sub AllXL()
Dim strFileName As String
Dim strPath As String
Dim strExt As String
Dim rng As Range
 
    strExt = "xl"
    strPath = "C:\" '
    
    Set rng = Range("A1")
    
    strFileName = Dir(strPath & "*.*" & strExt & "*")
    
    Do
        
        
        rng.Value = strFileName
        
        Set rng = rng.Offset(1)
    
        strFileName = Dir()
        
    Loop Until strFileName = ""
    
End Sub

The next step would be to add code to open the files an run your code.

Mind you the first step should probably be to write the code you want to run on each file, and write it in a way so it will work for them all.