sorting through the folder using macro

[sisi001]

Can anyone please help me with a macro code that can:

go through the folder with path (D:\user\desktop\foldername) and find files with name that contains "xxx_dataspecs.xls" in its name. and once it finds that name, it needs to go through my macro code "architecture" and once done with the code, find another file to run again. It needs to do this processuntil it runs out of files with that name in that folder....


Please please please help me!!!!

Thank You in advance.
sisi001

 

[VoG]

Try like this

Sub DoFiles()
Dim MyFolder As String
Dim MyFile As String
MyFolder = "D:\user\desktop\foldername"
MyFile = Dir(MyFolder & "*_dataspecs.xls")
Do While MyFile <> ""
    Workbooks.Open Filename:=MyFolder & "\" & MyFile
'
' do summat here
'
    ActiveWorkbook.Close savechanges:=True
    MyFile = Dir
Loop
End Sub

 

[sisi001]

Thank You very much. This solves my problem.