R
RickW
I have an application that generates Excel reports every day. The last part
of the file name is the run date otherwise the file name are constant e.g.
"FileName_yymmdd.xls".
The latest file is stored in the current report folder and the previous is
moved to an archive so in the current folder there is only one copy of each
report and it is the current days report.
I have another application that needs to open specific reports from the
current folder. This is where I need to use a wildcard to represent the date
in the command line. I have tried the following examples but none of them
are any good.
"FileName_"*".xls"
"FileName_"&*&".xls"
"FileName_" & * & ".xls"
"FileName_*.xls"
etc. etc
What am I missing here? or is it simply not possible to do this?
Looking forward to replies!
Rick
of the file name is the run date otherwise the file name are constant e.g.
"FileName_yymmdd.xls".
The latest file is stored in the current report folder and the previous is
moved to an archive so in the current folder there is only one copy of each
report and it is the current days report.
I have another application that needs to open specific reports from the
current folder. This is where I need to use a wildcard to represent the date
in the command line. I have tried the following examples but none of them
are any good.
"FileName_"*".xls"
"FileName_"&*&".xls"
"FileName_" & * & ".xls"
"FileName_*.xls"
etc. etc
What am I missing here? or is it simply not possible to do this?
Looking forward to replies!
Rick