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

[George J]

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]

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]

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