Page 1 of 2 12 LastLast
Results 1 to 10 of 12

How do I save a single specific sheet from a workbook

This is a discussion on How do I save a single specific sheet from a workbook within the Excel Questions forums, part of the Question Forums category; How do I save a single specific sheet from a workbook as a seperate entity without all the rest of ...

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Australia
    Posts
    31

    Default

    How do I save a single specific sheet from a workbook as a seperate entity without all the rest of the workbook being saved too.

    Would this saved sheet be auto updated if i did further work on the sheet within the workbook and just saved the workbook in its entirety.

  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default

    EDIT|MOVE_COPY_SHEET to a new workbook -- then save the new workbook.

    Regards!

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    538

    Default

    to save a single sheet only you need to copy the sheet to another workbook and save the new workbook.

    to enable what you want with autoupdating then you should
    1. make sure calculations are set to manual
    2. run the sheet calculation fxn(tools/options/calulation/calculate sheet) when you are in the neccesary sheet to be updated.

    [ This Message was edited by: Qroozn on 2002-05-07 15:58 ]

  4. #4
    New Member
    Join Date
    May 2002
    Location
    Australia
    Posts
    31

    Default

    Thanx Yogi!! Some sthings are so easy you fall over them. I'm a **** Fool and I don't care. Just love fooling with computers and learning, Al the time learning learning Ha Ha Ha
    Good on Ya mate Cheers Coco
    On 2002-05-07 15:56, Yogi Anand wrote:
    EDIT|MOVE_COPY_SHEET to a new workbook -- then save the new workbook.

    Regards!

    [/quote]

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default

    Hi cocosoft:
    You are doing great buddy! any guy who will venture to write an invoicing program for a mate has got be a great guy.

    Cheers!

  6. #6
    New Member
    Join Date
    May 2002
    Location
    Australia
    Posts
    31

    Default

    Thanx to you too Qroozn
    Just need to adjust the macro i was helped with earlier in the week to read my customer name cell, quote number cell, stitch em together copy sheet to new workbook and save as the resultant compound name. Any further sexy ideas on how I do that?
    Don't strain the brain mate, you guys are so helpful you are making the learning curve a lot easier than I expected. Thanx again Coco
    On 2002-05-07 15:57, Qroozn wrote:
    to save a single sheet only you need to copy the sheet to another workbook and save the new workbook.

    to enable what you want with autoupdating then you should
    1. make sure calculations are set to manual
    2. run the sheet calculation fxn(tools/options/calulation/calculate sheet) when you are in the neccesary sheet to be updated.

    [ This Message was edited by: Qroozn on 2002-05-07 15:58 ]
    [/quote]

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    538

    Default

    No worries coco.

    I am actually doing the same thing as you for my company (except i am a trainee). I have got an invoicing program which on acceptance of a job finds the customer.. inserts their details in the invoice sheet, inserts a job number, and invoice number, and then saves the details to an external invoice database.

    Its always fun to push your limits and see what you can amaze yourself with.

  8. #8
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,702

    Default

    May want to give the following a look:

    Code:
    Sub fsy()
    fname = Sheets(2).[a1].Value & " " & _
    Sheets(2).[a2].Value
    Sheets(1).Copy 'Copy first sheet to a new workbook
    ChDrive ("C") ' drive letter
    ChDir ("c:temp") ' target directory
    If fname <> "" Then 'make sure fname is not blank
        ActiveWorkbook.SaveAs Filename:=fname & ".xls"
        Else: MsgBox "Please Enter a value in A1 and retry."
    End If
    End Sub
    change:
    Sheets(2).[a1].Value & " " & _
    Sheets(2).[a2].Value
    To the appropriate sheets and ranges. Hope this helps.

    _________________
    Cheers, Nate

  9. #9
    New Member
    Join Date
    May 2002
    Location
    Australia
    Posts
    31

    Default

    Thanks NateO
    You people are too much, I've never before stumbled onto such a helpful group of people in all my life-- To all those offering Cocosoft help since i joined the board recently, give yourselves a bloody big pat on the back. I'm loving this, I'm usually on the other side of the coin answering questions for other people in my own areas of expertise, with rarely a "thank you" but you guys are the bees knees . Have a flaming great day, sure i'm going to have plenty more dumb questions for you all until such time as i learn a lot more. Reg to you all Coco
    On 2002-05-07 16:52, NateO wrote:
    May want to give the following a look:

    Code:
    Sub fsy()
    fname = Sheets(2).[a1].Value & " " & _
    Sheets(2).[a2].Value
    Sheets(1).Copy 'Copy first sheet to a new workbook
    ChDrive ("C") ' drive letter
    ChDir ("c:temp") ' target directory
    If fname <> "" Then 'make sure fname is not blank
        ActiveWorkbook.SaveAs Filename:=fname & ".xls"
        Else: MsgBox "Please Enter a value in A1 and retry."
    End If
    End Sub
    change:
    Sheets(2).[a1].Value & " " & _
    Sheets(2).[a2].Value
    To the appropriate sheets and ranges. Hope this helps.

    _________________
    Cheers, Nate

  10. #10
    New Member
    Join Date
    Mar 2004
    Posts
    35

    Default Re: How do I save a single specific sheet from a workbook

    explain how you change fname

Page 1 of 2 12 LastLast

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
  •  


DMCA.com