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

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"

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

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?

--
Regards,
Michael


"Jim Cone" wrote:

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"

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