Opening a file that changes dates

[Guest]

How would you call a file in VB if the file name is always preceeded by the
date. How did I get a macro to open up a file that is named the same all the
time, but has the date at the end always changed?

 

[Jim Cone]

Michael,
Why don't you post some typical file names.
Also tell us how you determine what file you want to open.
Jim Cone
San Francisco, USA


"Michael from Austin"
<[email protected]>
wrote in message
How would you call a file in VB if the file name is always preceeded by the
date. How did I get a macro to open up a file that is named the same all the
time, but has the date at the end always changed?--
Regards,
Michael

 

[Guest]

OK.. File name would be like

WA 10-07-05 today. If I ran the macro tomorrow, the file would then be WA
10-08-05, It would not go and open this file because the name is not coded in
VB. I want to be able to have the code reference todays date and then be able
to open and write to and or copy information from it... Can this be done?