Results 1 to 7 of 7

Thread: Macro to transfer data from open workbook to closed workbook with accumulation

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    Moderator
    Join Date
    Jul 2012
    Posts
    156
    Rep Power
    14
    Different angle. Only 1 macro in WB Total.
    On firing the code FilePicker will open, select desired invoice, invoice will open, numbers will be copied, invoice is closed.
    Code:
    Sub tst()
        With Application.FileDialog(msoFileDialogFilePicker)
            .Show
            Workbooks.Open .SelectedItems(1)
        End With
        Set wbTo = ThisWorkbook.Sheets("Total")
        With ActiveWorkbook
            With .Sheets(1)
                wbTo.Range("B" & Rows.Count).End(xlUp).Offset(1).Resize(, 8) = Array(.Range("D5"), .Range("C51"), , _
                        .Range("H48"), .Range("F29"), .Range("A29"), .Range("A30"), .Range("B46"))
            End With
            .Close False
        End With
    End Sub
    Last edited by bakerman; 08-25-2013 at 10:49 AM.

Similar Threads

  1. Open And Activate Workbook Before Runing Macro
    By Howardc in forum Excel Help
    Replies: 5
    Last Post: 06-04-2013, 07:23 PM
  2. Replies: 0
    Last Post: 04-20-2013, 10:07 AM
  3. VBA Code to Open Workbook and copy data
    By Howardc in forum Excel Help
    Replies: 16
    Last Post: 08-15-2012, 06:58 PM
  4. Update data from closed workbook with sumif formula
    By leopaulc in forum Excel Help
    Replies: 4
    Last Post: 11-02-2011, 02:58 AM
  5. Split Closed Workbook into Multiple Workbooks Using ADO
    By ramakrishnan in forum Excel Help
    Replies: 4
    Last Post: 10-02-2011, 08:34 PM

Posting Permissions

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