Macro to create a new workbook, copy sheet, but then...

George J · Feb 18th, 2002, 10:50 AM

After the sheet has been copied to the new workbook, a value will be changed in the original sheet, (old workbook), which will alter all the data and should be copied to the workbook just created. This will create a number of worksheets in the new book, but I also want the sheet names to default to whatever is in cell A7.

This one is making me dizzy. I think I have all the other parts figured out but 'til I get started I won't really know.

Any help or advice appreciated.

_________________
George J

[ This Message was edited by: George J on 2002-02-18 09:53 ]

Dan Aragon · Feb 18th, 2002, 12:44 PM

Well, I have some questions, but maybe this line of code will answer your question.

ActiveSheet.Name = Range("A7").Value

That will rename the active worksheet to the value in A7. Let me know if you need more assistance than that.

George J · Feb 18th, 2002, 04:13 PM

I knew it. I've lost the plot.
I'll try to be more concise now that the voices have stopped for a while.

Examples I have seen of opening new workbooks through a macro enable the user to have single sheet workbooks.

I would like to know how to ensure that after I have opened a workbook, the next sheet I try to copy across will go to the corect place as the workbook will not yet be named and will not be the active workbook as the code will hopefully be changing cell A7 in the original workbook (this sheet will then be copied to the new workbook etc).

I am not going in to too much detail as it will be a lot of work to answer rather than me picking brains (this does make me sound mad)

I will not get a chance to see the board again until Thursday, but if I still can't get it

I'll be back!

_________________
George J

[ This Message was edited by: George J on 2002-02-18 15:14 ]

[ This Message was edited by: George J on 2002-02-18 15:16 ]

[ This Message was edited by: George J on 2002-02-18 15:17 ]

[ This Message was edited by: George J on 2002-02-20 13:56 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 18th, 2002, 10:50 AM	#1
George J Board Regular Join Date: Feb 2002 Location: Edinburgh, Bonnie Scotland Posts: 820	After the sheet has been copied to the new workbook, a value will be changed in the original sheet, (old workbook), which will alter all the data and should be copied to the workbook just created. This will create a number of worksheets in the new book, but I also want the sheet names to default to whatever is in cell A7. This one is making me dizzy. I think I have all the other parts figured out but 'til I get started I won't really know. Any help or advice appreciated. _________________ George J [ This Message was edited by: George J on 2002-02-18 09:53 ]

Feb 18th, 2002, 12:44 PM	#2
Dan Aragon MrExcel MVP Join Date: Feb 2002 Location: Minnesota Posts: 92	Well, I have some questions, but maybe this line of code will answer your question. ActiveSheet.Name = Range("A7").Value That will rename the active worksheet to the value in A7. Let me know if you need more assistance than that.

Feb 18th, 2002, 04:13 PM	#3
George J Board Regular Join Date: Feb 2002 Location: Edinburgh, Bonnie Scotland Posts: 820	I knew it. I've lost the plot. I'll try to be more concise now that the voices have stopped for a while. Examples I have seen of opening new workbooks through a macro enable the user to have single sheet workbooks. I would like to know how to ensure that after I have opened a workbook, the next sheet I try to copy across will go to the corect place as the workbook will not yet be named and will not be the active workbook as the code will hopefully be changing cell A7 in the original workbook (this sheet will then be copied to the new workbook etc). I am not going in to too much detail as it will be a lot of work to answer rather than me picking brains (this does make me sound mad) I will not get a chance to see the board again until Thursday, but if I still can't get it I'll be back! _________________ George J [ This Message was edited by: George J on 2002-02-18 15:14 ] [ This Message was edited by: George J on 2002-02-18 15:16 ] [ This Message was edited by: George J on 2002-02-18 15:17 ] [ This Message was edited by: George J on 2002-02-20 13:56 ]