| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open File Dialog box looks like | Excel Discussion (Misc queries) | |||
| Open Dialog Box to return Selected File Path and Not Open it. | Excel Programming | |||
| File open dialog | Excel Discussion (Misc queries) | |||
| open file dialog-select file-import worksheet | Excel Programming | |||
| File open dialog | Excel Programming | |||
![scantor145[_19_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
