Results 1 to 5 of 5

saving only one sheet

Threaded View

  1. #1
    Registered User
    Join Date
    03-24-2010
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    50

    saving only one sheet

    hi all

    now I'm using save copy macro for saving entire workbook but I would like to have the same but for saving only one sheet from workbook can someone correct my code?

    here is code I use now

        ThisFile = "br-" & Range("D5").Value & "_" & Range("D4") & ".xls": FileFormatNum = 56
        ThisWorkbook.SaveCopyAs Filename:="D:\backup\" & ThisFile
    thank you
    Last edited by perko121; 03-26-2010 at 06:55 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1