Hi,
I have been working with you since two years on this. You are doing great. I have another issue now with “CalculateFormula” function. I am giving the scenario below what i am doing in my application.
I need to generate reports ( in PDF format) from Excel Work books.
i have to open multiple workbooks and do load the data from database and do some changes to the work books and after i need to call “Calculateformula” function to do the calculations and generate the Report.
-
Loading the Criteria work book to the Dictionary Object
-
Loading the Data work book to the Dictionary Object and load data to all work sheets from database.
-
Loading the Report templates (excel work books) to the Dictionary Object
-
Calling the Recalculate Formula function by linking the Criteria, Data and Report Templates.
-
Saving the workbooks as a PDF Documents.
In the above scenario, the “calculate formula” function is not working correctly with the workbooks (new data) exist in the Dictionary Object.
“Calculate Formula” function doing the calculation on Original Workbooks ( old data).So i am not getting correct results.
Please suggest me , how to implement the Calculations on workbooks which are exist in the Dictionary Object.
i am copying the code for your reference.
Thanks,
Sree