In an Excel spreadsheet, given a cell that has the formula:
='C:\Work\Finance\[TESTUPLOAD_base.xls]Sheet1'!$F$15
How can I get the file and path name in that formula?
Todate, I have only been able to get the actual formula (Sheet1'!$F$15)
and not the external file name or the path to it.
I've tried cell.getFormula, but again that only returns the formula and
NOT the file and path name contained in formulas that have references
to external spreadsheets.
Any assistance would be greatly appreciated.
Regards
Jeff Kohler
Computer Sciences Corporation
Registered Office: 2100 East Grand Avenue, El Segundo California 90245,
USA
Registered in USA No: C-489-59
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery.
NOTE: Regardless of content, this e-mail shall not operate to bind CSC to
any order or other contract unless pursuant to explicit written agreement
or government initiative expressly permitting the use of e-mail for such
purpose.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
