Macro code to transfer data to another file

**RA_Lek** · 01-01-2015, 08:46 AM

Hi Guys,

I would like to ask if there's a Macro Code to transfer the data to another file without opening the other file. I've attached 2 files (Tracker Leave & Master File). The Tracker Leave it is where we input all the data then later on I'll transfer it to another file which I named as Master File (no need to open this file).

Thanks!

**oct2mine** · 01-01-2015, 08:59 AM

i also need this one, hope there's someone that could solve this thread

**davesexcel** · 01-01-2015, 09:36 AM

You will have to open the workbook to write data into it.
But you can do it very fast.

Sub Button1_Click()
    Dim dir As String, Fnm As String, Crg As Range
    Dim wb As Workbook, Twb As Workbook, Tsh As Worksheet, sh As Worksheet
    Set Twb = ThisWorkbook
    Set Tsh = Twb.Worksheets("Tracker")
    Set Crg = ActiveCell
    dir = "C:\Users\Dave\Downloads\"    'change file directory
    Fnm = dir & "Master File.xlsx"
    Application.ScreenUpdating = 0
    With Tsh
        Set wb = Workbooks.Open(Fnm)
        Set sh = wb.Worksheets("Master")
        Crg.EntireRow.Copy sh.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
        With wb
            .Save
            .Close
        End With
    End With
    MsgBox "Done"    'delete later
End Sub

See the attached.
Adjust folder locations and file names accordingly.

**RA_Lek** · 01-01-2015, 10:55 AM

Hi davesexcel,

It's works! But what if I want to transfer like in range? Would that be possible?

Thanks!

**Kaper** · 01-01-2015, 11:37 AM

You can still use this code to transfer a range
Try small change at the beginning:

    Set Crg = range("A2:F"&cells(rows.count,"A").end(xlup).row)

and slight change later on

        Crg.Copy sh.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)

**RA_Lek** · 01-01-2015, 11:56 AM

Hi Kaper!

That's awesome!!! Thanks for the help Kaper and also to davesexcel.

)

Regards,

**oct2mine** · 01-03-2015, 02:20 AM

Hi RA_Lek,

does the codes perfectly works for you? I am still having a problem with this because when i clicked button 1 all data from tracker leave is being copied in master file. is it posible that only the new data that i added on the tracker leave will be added to the master leave? for example: if i added four leaves for four employee, then only those four will be added to the master list. hope someone could help me again regarding this.

thanks

**oct2mine** · 01-04-2015, 08:09 PM

I've already figured it out how this works. this thread should be marked as "Solved"

Thanks Davesexcel and Kaper for the help

Macro code to transfer data to another file

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Macro code to transfer data to another file

Re: Macro code to transfer data to another file

Re: Macro code to transfer data to another file

Re: Macro code to transfer data to another file

Re: Macro code to transfer data to another file

Re: Macro code to transfer data to another file

Re: Macro code to transfer data to another file

Re: Macro code to transfer data to another file

Thread Information

Users Browsing this Thread

Similar Threads

Macro to transfer data from multiple workbooks into separate sheets of master file

Macro to Open a file, transfer data, save and close

macro to transfer data from one file to another

Keep code in template, do not transfer to new file

2nd try --Macro to transfer data in an Excel sheet (2000) in Access 2000 ( code to replace what wizard do)

Bookmarks

Bookmarks

Posting Permissions