data transfer between 2 files

[mvel_sky]

Conditions:

- There are 2 workbooks in a same folder, let us say A & B.

- Macro has been written to transfer datas from workbook "A" to "B".

- File name of workbook "B" is referenced in workbook "A" thro' vba programming for data transfer.

- Now if i change the file name of workbook "B" then data tranfer should not get effected.

- Changed filename should get automatically updated in the VBA programming in workbook "A".

Please go thro' the above conditions and help me.

Thanks
M.Velmurugan

[ravishankar]

Hi
What is the range of data you wish to transfer to B?
Ravi