Results 1 to 2 of 2

Macro to move to another spreadsheet is pasting links instead of values

Threaded View

  1. #1
    Registered User
    Join Date
    04-26-2011
    Location
    Tempe Az
    MS-Off Ver
    Excel 2003
    Posts
    3

    Macro to move to another spreadsheet is pasting links instead of values

    I am working on a tracking spreadsheet, The Macro I have to take the data from a slave spreadsheet and present it into a master works great, except it is pasting links instead of values. I have run against a wall and cannot get it to work properly. Any help would be wonderful. Here is what I have
    Sub WriteToMasterList_v2()
    Dim curName As String
    Dim nxtRw As Integer
    curName = ActiveWorkbook.Name
    'Open Master Workshop List.xls (Hidden if saved Hidden)
      Workbooks.Open Filename:="C:\Documents and Settings\64h9978\my documents\excel\master workshop list.xls"
    'Determine next empty row in master workshop list.xls
       nxtRw = Workbooks("master workshop list.xls").Sheets(1).Range("A" & Rows.Count).End(xlUp).Row + 2
    'Copy Activeworkbook row to to log.xls
        Workbooks(curName).Sheets(3).Rows("1:8").Copy _
             Destination:=Workbooks("Master Workshop List.xls").Sheets(1).Rows(nxtRw)
           Application.CutCopyMode = False
                  
    'Save and close log.xls
           Workbooks("Master Workshop List.xls").Save
    Last edited by dstoltz; 04-26-2011 at 04:34 PM. Reason: Bad title and no code marks

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