Check for existance of a file

[jgelpi16]

I have a file that is generated nightly. Each morning the user will come in and open the DB. I need the file to be automatically imported. Here is my dilemma. The file has the previous day's date on the end (i.e. NewFile_11092010.txt). Instead of trying to calculate weekends and holidays (File is only generated on working business days) I would like to just check for any file with the root of "Newfile_". Part of my import process daily is to archive the file so there will never be more than one file with the same root at my location. Any tips or documentation will be much appreciated!

[jgelpi16]

Used the "Dir()" function...

http://office.microsoft.com/en-us/ac...001228824.aspx

Dim varPath
dim varResult
varPath = "C:\Path\NewFile_*.txt"
varResult = Dir(varPath)