QuantlibXL: Automatically store objects while opening a spreadsheet

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

QuantlibXL: Automatically store objects while opening a spreadsheet

Lapin
Hi,

I am trying to do the same this that has been done in the framework.xla:

1- open a workbook for the Quotes
2- Close it (with or without calculate it does not sole the issue)
3- open a workbook for the Quotefeed

At this moment, the ObjectID that were supposed to be created in the Quote workbook do not exist.
To make it work, I have to open the Quote workbook and to do F2-Return on every cells that contain the ObjectID.

Does anybody know how to do this step automatically?

Thaks