|
Posted to microsoft.public.excel.programming
|
|
|
directory listing in listbox
hi,
see this site.
http://j-walk.com/ss/excel/tips/tip29.htm
regards
FSt1
"br549" wrote:
I have a little experience manipulating data in Excel using VBA, but no
experience with userforms. Is there a relatively simple way to fill a listbox
with the contents of a folder so the user can be presented with a choice of
files that will be used for some calculations? Goal is for user to select a
file from the list box, then the VBA code will pull certain data out of that
file for a calculation.
Thanks,
Rob
|