Open File Dialog Box on UserForm
 

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?


--
scantor145
------------------------------------------------------------------------
scantor145's Profile: http://www.excelforum.com/member.php...o&userid=14766
View this thread: http://www.excelforum.com/showthread...hreadid=390288

Open File Dialog Box on UserForm
 

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.

--
Regards,
Tom Ogilvy

"scantor145" wrote
in message ...

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?


--
scantor145
------------------------------------------------------------------------
scantor145's Profile:
http://www.excelforum.com/member.php...o&userid=14766
View this thread: http://www.excelforum.com/showthread...hreadid=390288