Page 1 of 1

Formula with external reference

Posted: Tue Apr 03, 2007 7:11 pm
by Guest
How to read Formula in cell with reference on external xls-file?
AsFormula[col, row] returns
''??..\..\..\..\..\??..\..\..\..\..\..\?..\..\..\..\..\..\..\..\?..\?..\..\..\??..\..\..\..\..\..\..\..\..\..\?..\..\..\..\..\..\..\..\..\..\..\..\..\?..\..\..\???'#0'Sheet1'!$F$35'

Posted: Thu Apr 05, 2007 7:28 am
by larsa
Hello

Can you send me the excel file that contains this formula?


Lars Arvidsson