Browsing

Resolved · Low Priority · Version 2003

Fri 13 Jun 2008, 15:07 Delegate Oliver said...

Oliver has attended:
Excel VBA Intro Intermediate course

Browsing

Create vba code to browse your c:?

Sun 15 Jun 2008, 19:16 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips