Browsing

Hi Oliver,

Hope you found the training useful. Regarding to your question, you can add create a macro or draw a command button to attach the following code:

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Dim FileName As String

ChDir "C:\"
FileName = Application.GetOpenFilename

Exit Sub
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

The application method GetOpenFilename brings up the Open File window while ChDir changes to looks into a file path.

See if this helps.

Regards,

Katie
Microsoft Certified Trainer