Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate listBox
Hi All
How do I go about populating a listbox. with file names from a directory. I can do this in VB but can't find anything in excel thank you Phill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate listBox
Dim sPath as String
Dim sFname as String sPath = "C:\Myfolder\*.xls" sFname = Dir(sPath) Do while sFname < "" Listbox1.AddItem sFname sFName = dir() Loop -- Regards, Tom Ogilvy "Hamster" wrote in message ... Hi All How do I go about populating a listbox. with file names from a directory. I can do this in VB but can't find anything in excel thank you Phill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
populate ldropdown listbox from a dbf. file | Excel Discussion (Misc queries) | |||
Array to Populate ListBox Problem | Excel Discussion (Misc queries) | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
ListBox Populate | Excel Programming | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |