08-27-2014 02:36 PM
Hello, I am trying to open a file with a name like: "1000_Test_1.csv"
The problem exists because the "_1.csv" can contain any number, which I do not care about. The main this I need make sure of is that the "1000_Test" section is correct. Is there any way to use a wildcard when calling the file?
An example of the code I am currently using is listed below.
Thanks.
Call DataFileLoad("C:\Users\Me\Somewhere\DIAdem Tests\Folde\" & run_num & "_Test*","csv")
08-28-2014 07:29 AM
Option Explicit dim entries : entries = DirListGet("C:\temp", "1000_Test_*.csv", "filename", "FullFilenames") If IsArray(entries) Then dim entry : for each entry in entries MsgBox entry Call DataFileLoad(entry,"csv") Next end if
You can use code like this