Using variables in a name

[Vispy]

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!!

[Bob Phillips]

fname = "Labor-Work-" & Format(mth,"00") "-" % Format(yr,"0000")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Vispy" <[email protected]> wrote in message
news:[email protected]...
> 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!!
>
>

[Kevin Vaughn]

fname = "Labor-Work-" & mth & "-" & yr

> mth = 1
> yr = 2006
>
> fname = "Labor-Work-mth-yr"
>
> I would like to have fname appear as Labor-Work-01-2006.
--
Kevin Vaughn


"Vispy" wrote:

> 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$
>

>
>
> Thanks!!
>
>
>

[Vispy]

Thanks to Bob & Kevin!!

"Vispy" <[email protected]> wrote in message
news:[email protected]...
> 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!!
>

[Kevin Vaughn]

You're welcome. Although I did miss the 0 before the month part.
--
Kevin Vaughn


"Vispy" wrote:

> Thanks to Bob & Kevin!!
>
> "Vispy" <[email protected]> wrote in message
> news:[email protected]...
> > 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!!
> >
>
>
>