Probably no easy way to do that unless you want to treat both of the closed
workbooks as databases and use ADO or some such.

How hard it is it to use the code to open the workboooks, copy the data,
save the changed workbook, close the workbooks.

--
Regards,
Tom Ogilvy


"brucelim80" wrote
in message ...

hi,

Can anyone help me with this problem?

I have three workbook place in different directories


Workbook A consist of original data
Workbook B consist of old data
Workbook C shall be use to run a macro with inbuilt button.


How to i make workbook C (with marcro) to copy the data from Workbook A
to workbook B without opening both A and B?

Can anyone provide me a sample of the code?

Thank you


--
brucelim80
------------------------------------------------------------------------
brucelim80's Profile:
http://www.excelforum.com/member.php...o&userid=32244
View this thread: http://www.excelforum.com/showthread...hreadid=551238