c:\test\excel1.xls
this excel1 has a lot of link to other files to another folder lets says c:\test\excelfiles\
so cell[1,1] from c:\test\excel1.xls is linked to c:\test\excelfiles\[a.xls]sheet1'!A1
I have a VBA and using filecopy to folder c:\test\destination, the link of excel1.xls in this destination folder is changing to c:\test\[a.xls]sheet1'!A1 instead of remaining to the original link which is c:\test\excelfiles\[a.xls]sheet1'!A1.
why is this happening?? any solution so that wehn i use filecopy the initial link remains intact?
this excel1 has a lot of link to other files to another folder lets says c:\test\excelfiles\
so cell[1,1] from c:\test\excel1.xls is linked to c:\test\excelfiles\[a.xls]sheet1'!A1
I have a VBA and using filecopy to folder c:\test\destination, the link of excel1.xls in this destination folder is changing to c:\test\[a.xls]sheet1'!A1 instead of remaining to the original link which is c:\test\excelfiles\[a.xls]sheet1'!A1.
why is this happening?? any solution so that wehn i use filecopy the initial link remains intact?
