View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Kevin Vaughn
 
Posts: n/a
Default 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!!