I am attempting to execute a transfertext statement to import a file. The file contains a time stamp. Is there anyway to have a wildcard character as a part of the file name without it being recognized as a literal character?
The file name would be in the form of:
DECO_RECON_052810_080006.txt
with the red portion being a time stamp.
if i use this lines of code to set the file path:
[vba]filename = "x:\frankford\refrec\DECO_RECON_" & newdate & "*.txt"
[/vba]
where newdate is set to an inputbox prompting the user for a date i get:
x:\frankford\refrec\DECO_RECON_newdate_*.txt
which needs to look like this:
x:\frankford\refrec\DECO_RECON_newdate_080006.txt
the problem is the red text will be different from day to day.
Any thoughts on how to do this?
Thanks in advance.