I have a daily file to import. If I hard code the entire file name my code works. My problem is getting around the daily name change of the file.
The owner has an automated process that creates the file so the name every day is slightly different due to the timestamp. Here's an example
Today's file is "mydailyfile_20140317_1035.xls"
Tomorrow will be "mydailyfile_20140318_1033.xls"
I can account for date using "sFileDate = Format(Now(), "yyyymmdd")"
The hour/minutes is never the same.
Is there a wildcard solution??
Thanks
JB
The owner has an automated process that creates the file so the name every day is slightly different due to the timestamp. Here's an example
Today's file is "mydailyfile_20140317_1035.xls"
Tomorrow will be "mydailyfile_20140318_1033.xls"
I can account for date using "sFileDate = Format(Now(), "yyyymmdd")"
The hour/minutes is never the same.
Is there a wildcard solution??
Thanks
JB