Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Save sheet as? Thanks Jay!

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey guys!

    I have a workbook with a sheet called Report Template.
    I would like for VBA to create a new workbook, with one sheet, using the template from the workbook which created the new workbook.

    Report Template is sheet4

    Will you help me from here?

    Workbooks.Add
    ?
    ?

    Thanks,
    Tom

    [ This Message was edited by: TsTom on 2002-04-06 17:27 ]

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-06 16:35, TsTom wrote:
    Hey guys!

    I have a workbook with a sheet called Report Template.
    I would like for VBA to create a new workbook, with one sheet, using the template from the workbook which created the new workbook.

    Report Template is sheet4

    Will you help me from here?

    Workbooks.Add
    ?
    ?

    Thanks,
    Tom
    Hi Tom,

    Try

    Sheets("Report Template").Copy

    This will copy the sheet to a new workbook.

    Regards,
    Jay

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Jay!
    Is what I needed!
    Tom

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
  •