Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

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

  1. #1
    Board Regular George J's Avatar
    Join Date
    Feb 2002
    Location
    Edinburgh, Bonnie Scotland
    Posts
    954
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Minnesota
    Posts
    92
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    Board Regular George J's Avatar
    Join Date
    Feb 2002
    Location
    Edinburgh, Bonnie Scotland
    Posts
    954
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •