Using variables in a name
You're welcome. Although I did miss the 0 before the month part.
--
Kevin Vaughn
"Vispy" wrote:
Thanks to Bob & Kevin!!
"Vispy" wrote in message
...
Hello,
Does anyone know how to used a variable in a name?
My example would by:
' fname is short for the name to be given to the newly saved file.
Dim fname$
' dt is short for the date.
Dim dt$
' mth is short for the month.
Dim mth$
mth = 1
yr = 2006
fname = "Labor-Work-mth-yr"
I would like to have fname appear as Labor-Work-01-2006.
Thanks!!
|