Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Browsing
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Browsing
Resolved · Low Priority · Version 2003
Reply Fri 13 Jun 2008, 15:07Delegate Oliver said...
For upcoming training course dates see: Pricing & availability
RE: 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
|