Success!!
I was able to initialize model.Workbook by using ExternSheetRecord (for
sheet reference) and BoundSheetRecord (for sheet name) and achieve what
I have been intending to do with slight imperfection.
With a bit of VBA help I was able to iterate through the workbook and
set those forced excel text string back into formula.
The only imperfection is that the external file reference (i.e.
"[c:\document\myxls.xls]Sheet1!A5:B20") does not seem to be included in
ExternSheet or BoundSheet, I suspect it will be in SST table. But I have
got enough to achieve what I need. thanks Nick.
Andy Chien
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
