naming a file based on cell value?

i have a monthly report that gives me portfolio for each customer.name of
the sheets are generic (somethingxx where xx is number).i allready made
macro that take sheet after sheet and saves it as separate excel file but
then i must look into each file and rename it.can some value from the sheet
be used for a name of a file?

how can this be done?


thx


rene

You could use something like

With ActiveSheet
.Name = .Range("A1").Value
End With

and change Activesheet to however you are addressing the sheet

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"nokia3650" <[email protected]> wrote in message
news:[email protected]...
i have a monthly report that gives me portfolio for each customer.name of
the sheets are generic (somethingxx where xx is number).i allready made
macro that take sheet after sheet and saves it as separate excel file but
then i must look into each file and rename it.can some value from the sheet
be used for a name of a file?

how can this be done?


thx


rene

thanks

that was so simple i am ashamend that i dint it figured out.

once again

htanks


rene
"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> You could use something like
>
> With ActiveSheet
> .Name = .Range("A1").Value
> End With
>
> and change Activesheet to however you are addressing the sheet
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "nokia3650" <[email protected]> wrote in message
> news:[email protected]...
> i have a monthly report that gives me portfolio for each customer.name of
> the sheets are generic (somethingxx where xx is number).i allready made
> macro that take sheet after sheet and saves it as separate excel file but
> then i must look into each file and rename it.can some value from the
sheet
> be used for a name of a file?
>
> how can this be done?
>
>
> thx
>
>
> rene
>
>