I have an existing formula in a cell as : =[Sample.xls]OC1!$F$1
You will understand that it is taking the value of the Cell F1 of Sheet OC1 of the excel workbook Sample.xls
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>
I do not want to hardcode the...