File System Object

[magsmith]

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?

 

[Richard Schollar]

Hi

You can use the ancient GetOpenFileName method:

Dim varFile As Variant
varFile = GetOptnFileName()
If varFile<>False Then Workbooks.Open varFile

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.