- how to read certain files in a directory in excel VBA
- Sub GetFiles()
- Dim strFolder As String
- Dim strFileName As String
- Dim wb As Workbook
- strFolder = "C:temp"
- strFileName = Dir(strFolder & "*123.xls")
- Do While Len(strFileName) > 0
- Set wb = Workbooks.Open(strFileName)
- Debug.Print wb.FullName
- wb.Close False
- strFileName = Dir
- Loop
- End Sub