| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive, Dir and File list boxes?
Hello, EXCEL 2003 does not seem to have Drive, Directory and File listboxes like the ones available in VB. Is this true or have I just not found them, I have looked under 'more controls' but cannot find them. Is there a workaround or can I add a reference to the ones installed with VB6 and use them on my EXCEL userforms? Thanks -- tokyoprince ------------------------------------------------------------------------ tokyoprince's Profile: http://www.excelforum.com/member.php...o&userid=26530 View this thread: http://www.excelforum.com/showthread...hreadid=397986 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drive, Dir and File list boxes?
Excel does not have those controls. You can probably use
GetOpenFilename or GetSaveAsFilename instead. See help for more details. "tokyoprince" wrote in message ... Hello, EXCEL 2003 does not seem to have Drive, Directory and File listboxes like the ones available in VB. Is this true or have I just not found them, I have looked under 'more controls' but cannot find them. Is there a workaround or can I add a reference to the ones installed with VB6 and use them on my EXCEL userforms? Thanks -- tokyoprince ------------------------------------------------------------------------ tokyoprince's Profile: http://www.excelforum.com/member.php...o&userid=26530 View this thread: http://www.excelforum.com/showthread...hreadid=397986 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drive, Dir and File list boxes?
To supplement,
those controls are native to VB (built in controls) and can not be referenced. You could build a VB form with these controls and compile it as a DLL, then call it from Excel I believe. -- Regards, Tom Ogilvy "tokyoprince" wrote in message ... Hello, EXCEL 2003 does not seem to have Drive, Directory and File listboxes like the ones available in VB. Is this true or have I just not found them, I have looked under 'more controls' but cannot find them. Is there a workaround or can I add a reference to the ones installed with VB6 and use them on my EXCEL userforms? Thanks -- tokyoprince ------------------------------------------------------------------------ tokyoprince's Profile: http://www.excelforum.com/member.php...o&userid=26530 View this thread: http://www.excelforum.com/showthread...hreadid=397986 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2003 file converted to .xlsm file when save to network drive | Excel Discussion (Misc queries) | |||
| Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
| Questions on combo boxes and list boxes. | New Users to Excel | |||
| File in C drive is always trying to access Drive A | Excel Discussion (Misc queries) | |||
| List boxes/combo boxes | Excel Programming | |||
Linear Mode
