MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Windows with "File Locations"

Posted by Jugge on April 26, 2001 7:18 AM

I need a vba that open a explorer windows where the user can select the path och then the path is in a variabel (eg. pathen=c:\temp).


Posted by Dave Hawley on April 26, 2001 11:45 PM

Hi Jugge

Sub TryThis()
Dim sFileChosen As String
sFileChosen = Application.GetOpenFilename
If sFileChosen = "False" Then Exit Sub
MsgBox sFileChosen
End Sub

OzGrid Business Applications

Posted by Jugge on April 27, 2001 12:14 AM

Hello again.

All i need is the path, not the file. The user are showing the path for the vba program.