MrExcel.com - Your One Stop for Excel Tips & Solutions

VB code to open the open window

Posted by Damien on October 29, 2001 2:19 PM

I need the code to open the browser window to open a
file thru excel so the user can select the directory and point to a file ? Anyone

Posted by Tom Urtis on October 29, 2001 2:22 PM

Application.Dialogs(xlDialogOpen).Show

Posted by bob umlas on October 29, 2001 4:44 PM

MyFileAndPath = Application.GetOpenFileName()