sukantaswain
02-23-2012, 07:43 AM
Hi Friends,
I have a Excel file ,which is linked with two diffrnet excel files (C:\For\333.xls)
and (C:\Cob\C_333.xls).
like 333.xls and C_333.xls i have similar files 111.xls and C_111.xls in the respective folders.i have these kind of 200 or more files
I am trying to develop a vba module to calculate the variance between 333.xls and C_333.xls and looping the same for other files
please help me out for the vba code
Requirment
code to changing the excel link and update the value
loop the same code for other files like 111.xls and C_111.xls (file name mentioned in a templete)
please help me out !!
Sukant
I have a Excel file ,which is linked with two diffrnet excel files (C:\For\333.xls)
and (C:\Cob\C_333.xls).
like 333.xls and C_333.xls i have similar files 111.xls and C_111.xls in the respective folders.i have these kind of 200 or more files
I am trying to develop a vba module to calculate the variance between 333.xls and C_333.xls and looping the same for other files
please help me out for the vba code
Requirment
code to changing the excel link and update the value
loop the same code for other files like 111.xls and C_111.xls (file name mentioned in a templete)
please help me out !!
Sukant