multiple criteria for ListFilestoTable

[matt beamish]

Im using the Function "Listfilestotable" that I found here
http://allenbrowne.com/ser-59alt.html

to scan an area of shared drive for filenames which are then written into a table within a databse in order to populate subforms that relate to a database record via a folder name to record number match. This gives me an autoupdating list (so long as the function runs regularly) on what reports have actually been lodged on the drive, which is great.

At the moment I am triggering the function using a macro which also specifies that only pdf files across the area should be listed as I don't want to include all file types.

listfilestotable ("X:\blah\something","*.pdf*",True)

However I would like "*.doc*" as a criteria too, but I can't get this to work - If I change the criteria from being anything other than one type, the function runs, but generates no records - i.e. I am specifying my criteria wrongly.

Can anyone help on this? My other option is to run the function a second time, and append my *.doc* records to the table.

thanks

Matt

 

[DCrake]

Silly question but are there actually any .doc files in the chosen folder?

 

[matt beamish]

Oh yes, thousands.

 

[boblarson]

It would be possible to change the code to allow for a delimited list, but the simplest method is just to run it once for each file type.

 

[matt beamish]

OK thanks, Ill run it twice.
Matt