Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
naming a file based on cell value?
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
naming a file based on cell value?
thanks
that was so simple i am ashamend that i dint it figured out. once again htanks rene "Bob Phillips" wrote in message ... 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Table of Contents based on Heading style - not naming a ran | Excel Discussion (Misc queries) | |||
Naming cells in a table based on column and row label | Excel Discussion (Misc queries) | |||
cuting sheet and naming it based on value in specific cell? | Excel Programming | |||
naming .xls file based on a cell in excel | Excel Discussion (Misc queries) | |||
Naming File from a Cell | Excel Programming |