Getting a list of files in a folder

[Tom Ross]

I have a form that looks takes calculations from my database and inserts
them into spreadsheets in a folder.

Currently I have a table with a list of filenames. I loop through the
filenames and update the spreadsheets.

I would like to lread the list of files in a windows folder and load it into
a table, array, or text string that I can loop through

Thanks

Tom

 

[Andi Mayer]

I have a form that looks takes calculations from my database and inserts
them into spreadsheets in a folder.

Currently I have a table with a list of filenames. I loop through the
filenames and update the spreadsheets.

I would like to lread the list of files in a windows folder and load it into
a table, array, or text string that I can loop through

dim tmp as string, tmp1 as string
dim ary() as string
tmp=dir("C:\mydirectory\*.xls)
while tmp<>""
tmp1=tmp1 &"|" &tmp
tmp=dir()
wend
ary=split(mid(tmp1,2),"|")

in ary() you have all xls from the directory MyDirectory

 

[Tom Ross]

Thanks Andi

The split function didn't work right away but I didn't really need to load
them in an array just process the filenames as they are created

Tom