Results 1 to 2 of 2

Copy active workbook to and save new workbook Macro

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2015
    Location
    seattle Washington
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Copy active workbook to and save new workbook Macro

    I am trying to have my team click a button and have the active sheet copy to a new workbook and then save it based on the value of a specific cell. The issue I am running into is that it saves the original file and then copy's the workbook. I wont it to do the opposite. Here is the Formula I currently have.

    Sub Saveworksheet()
    '
    ' Saveworksheet Macro
    '   ActiveSheet.Select
        Dim FName As String
        Dim FPath As String
            
        FPath = "E:"
        FName = ActiveSheet.Range("K3").Text
        
        Sheet1.Copy
    ThisWorkbook.SaveAs Filename:=FPath & "\" & FName
    End Sub
    Last edited by JBeaucaire; 11-11-2015 at 07:24 PM. Reason: Added missing CODE /CODE tags. Please read and follow the Forum Rules, link above in the blue menu bar. Thanks.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run Macro in closed workbook and copy specific coloumn in active workbook
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2013, 03:43 AM
  2. Replies: 9
    Last Post: 06-24-2013, 04:14 PM
  3. VBA macro for hyperlink to active workbook in the active workbook path
    By Scott Taylor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-10-2013, 05:37 AM
  4. [SOLVED] Save Active Sheet As New Workbook in same folder of the original workbook
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-19-2012, 07:03 PM
  5. [SOLVED] copy active sheet, create new workbook, name new workbook based on cell reference
    By jm0392 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2012, 07:12 PM
  6. Replies: 0
    Last Post: 04-28-2012, 06:06 PM
  7. Command button - to copy active sheet and not save current workbook
    By vjboaz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2008, 05:23 PM
  8. [SOLVED] VB Method to copy and save only one sheet of the active workbook
    By Rock* in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2006, 08:35 PM

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