Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    save copy without a sheet (2000 sr 1)

    .... sure not for me!
    I use this code to save a file from active wbook named MASTER.XLS... is possible when i save the wbook delete the sheet "TEST", but maintain sheet "TEST" in original file?:

    Sub SAVE_2()

    Sheets("DB_TEST").Visible = False
    PERCORSO = "GCD01F4500DATIPUBBLICAINATTIVIGESTORIINATTIVI _" & Format(Date, "ddmmyyyy") & "_" & Worksheets("Saldi").Range("D1") & ".xls"
    ActiveWorkbook.SaveCopyAs PERCORSO
    Sheets("DB_TEST").Visible = True

    End Sub

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: save copy without a sheet (2000 sr 1)

    One option would be to delete the sheet DB_TEST (or TEST, whatever its name is) from the master workbook, then use SaveAs to save the workbook with the specified name. You'd then have to reopen the master workbook (which will be unchanged).
    Another option is to use SaveCopyAs to save a copy of the master workbook, then open the copy, delete the DB_TEST sheet and finally save and close the copy.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: save copy without a sheet (2000 sr 1)

    ....as you have made to understand that the sheet are db_test?????????????????

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: save copy without a sheet (2000 sr 1)

    Is that a question? If so, what do you mean?

Posting Permissions

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