SonicBoomGolf
Active Member
- Joined
- Aug 7, 2004
- Messages
- 325
I am looking for a piece of code that will open all the files contained within a specific folder. I imagine that it will look something like the sample code below (which is not working).
Sub TEST()
Dim Folder As String, File As String
Folder = "D:\jsmith\Desktop\TEST"
For Each File In Folder
File.Open
File.Close
Next File
End Sub
If I can just get the files in this folder to open and then close I can run the macro to extract data. Any help would be appreciated!! Thanks!!
Sub TEST()
Dim Folder As String, File As String
Folder = "D:\jsmith\Desktop\TEST"
For Each File In Folder
File.Open
File.Close
Next File
End Sub
If I can just get the files in this folder to open and then close I can run the macro to extract data. Any help would be appreciated!! Thanks!!