Richard,

With A1 = file
B1 = 9/15/2003 (US standard)
Dim filenm as String
filenm = Range("A1") & Format(Range("b1"), "mmmyy")

you may or may not need to adjust for your regional settings.
--
sb
"Richard Leclezio" wrote in message
...
i need to extract a file which the file name itself
contains a changing date of the form \"filename"&mmmdd
in trying to create the string so i can extract the
filename daily i create a cell reference with the
constant string and created the mmmdd date string in a
separate cell.. on attempting to combine the two strings
in order to come up with one filename the resulting
string results in the constanttext & the date in excel
number format
for example if today was 15/09/2003 i would wish to
create the string c:\\my videos\filesep15 but instead
get the result is c:\\my videos\file37879

could anyone help me in createing the former????
please :)

filenm = Range("A1") & Format(Range("b1"), "mmmyy")
msgbox filenm

--
Regards,
Tom Ogilvy


"Richard Leclezio" wrote in message
...
Hi steve,

sorry it seem stupid but after i have written that code
how do i view the combined result

R
-----Original Message-----
Richard,

With A1 = file
B1 = 9/15/2003 (US standard)
Dim filenm as String
filenm = Range("A1") & Format(Range("b1"), "mmmyy")

you may or may not need to adjust for your regional
settings.
--
sb
"Richard Leclezio"
wrote in message
...
i need to extract a file which the file name itself
contains a changing date of the form \"filename"&mmmdd
in trying to create the string so i can extract the
filename daily i create a cell reference with the
constant string and created the mmmdd date string in a
separate cell.. on attempting to combine the two strings
in order to come up with one filename the resulting
string results in the constanttext & the date in excel
number format
for example if today was 15/09/2003 i would wish to
create the string c:\\my videos\filesep15 but instead
get the result is c:\\my videos\file37879

could anyone help me in createing the former????
please :)



.