Open File Dialog Box on UserForm

[scantor145]

Excel 2003 w/Visual Basic 6.3

There is no Common Dialog Box control in VB 6.3. Is there another way
to place a File Open Dialog Box onto a UserForm?

 

[Tom Ogilvy]

Not on the form, but you can use

fname = Application.GetOpenfileName()

However, this seems to make the userform modeless, so you might hide the
form first, then reshow it after the file is selected. Note that the
GetOpenfileName does not open the file, just returns the file name selected.