VBA macros for data transfer between 2 files in same folder

**mvel_sky** · 02-06-2009, 05:56 AM

Dear All,

I need VBA macros for data transfer (cell in one file to cell in another file) between two files in the same folder, independent of the location the folder is stored.

**royUK** · 02-06-2009, 06:13 AM

Not much to go on.

Are the workbooks both open?
What are you copying & where to?

**mvel_sky** · 02-06-2009, 06:18 AM

one workbook will be open. i want to transfer text or numbers in cells of one workbook to the cells in another workbook.

**royUK** · 02-06-2009, 06:30 AM

Here's some code that you should be able to adapt

Please Login or Register  to view this content.

**mvel_sky** · 02-09-2009, 12:19 AM

Dear Sir,

Thanks for the code. It is excellent.

I thank you once again.

One more question sir,

What datatype has to be defined if i want to copy any data even if it is a error value (eg: #DIV/0!).

Thanks
Regards
M.Velmurugan