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
Bookmarks