I've created a tool that browses for a folder then checks the workbook for criteria and highlights cells depending if they meet it or not. I'm using a file system object to browse for a folder. It works fine if there is only one file in the folder, but not if there are multiple. Any suggestions on how to browse for a specific file?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
File System Object
- Thread starter magsmith
- Start date
Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
Hi
You can use the ancient GetOpenFileName method:
It's worth checking out the VBA Help topic on GetOpenFileName as there are parameters (eg file extension) that you can pass to the method to direct users.
You can use the ancient GetOpenFileName method:
Code:
Dim varFile As Variant
varFile = GetOptnFileName()
If varFile<>False Then Workbooks.Open varFileIt's worth checking out the VBA Help topic on GetOpenFileName as there are parameters (eg file extension) that you can pass to the method to direct users.
Upvote
0
