98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Browsing
Browsing
Resolved · Low Priority · Version 2003
Fri 13 Jun 2008, 15:07Delegate Oliver said...
Oliver has attended:
Excel VBA Intro Intermediate course
Browsing
Create vba code to browse your c:?
Sun 15 Jun 2008, 19:16Trainer Katie said...
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
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. |
Excel tip:Autofit column width – Excel (all versions)a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column. |
