Macro code to transfer data to another file

[RA_Lek]

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]

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

[davesexcel]

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

Please Login or Register  to view this content.

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

[RA_Lek]

Hi davesexcel,

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

Thanks!

[Kaper]

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

Please Login or Register  to view this content.

and slight change later on

Please Login or Register  to view this content.

[RA_Lek]

Hi Kaper!

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

Regards,

[oct2mine]

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]

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

Thanks Davesexcel and Kaper for the help