Results 1 to 4 of 4

Saving spreadsheets from a macro

Threaded View

  1. #1
    Registered User
    Join Date
    07-28-2010
    Location
    Lancs England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Saving spreadsheets from a macro

    Hi all!
    I am new to this forum, I like to work things out for myself but this problem has been driving me nuts!
    I have a macro which files a copy of the spreadsheet containing the macro to a folder and file specified within the worksheet then the worksheet closes.
    What I would like to do is save the file as a copy and close without closing the original.
    The code below is what I am working with:
    Sub saveas()
     
    Dim filelabel As Variant
     filelabel = Range("d62").Value
    
    Dim folder As Variant
    folder = Range("d63").Value
     
    ChDir folder
     
    ThisWorkbook.saveas Filename:=filelabel
     
    ThisWorkbook.Close
     
    End Sub
    I am sure this will be an easy one for someone
    Last edited by Leith Ross; 07-28-2010 at 04:06 PM. Reason: Added Code Tags

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