naming a file based on cell value?

  • Thread starter Thread starter nokia3650
  • Start date Start date
N

nokia3650

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)

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing sheet name based on a cell in another sheet 1
hide multiple worksheets based on a formula value in one cell 1
Sheet name=Cell value 2
Run macro from active workbook whose name keeps changing 20
Print sheets based on cell value 1
Macro to paste value to a file same as A1 10
Creating range name based on cell value. 6
Rename Sheets based on List 5

Back
Top