Ms. Manuel Ventura 0 Report post Posted July 9, 2015 Hi I want to be able to optimize a model implemented as an Excel workbook. I know that in CAESES there is a COM interface for connecting with Excel but I do not know how to use it and what are the functionalities available. Could anyone give me some guidance on how to:1. Connect CAESES with an existing Excel workbook file <*.xlsm>2. Change values in some given cells3. Read values from some given cells4. Write results to a new Excel file Some examples would be quite wellcome.Thank you in advance. Best regardsManuel ventura Share this post Link to post Share on other sites
Jörg 29 Report post Posted July 9, 2015 Hi Manuel, Please find attached a reviewed feature definition (just put it into your feature user directory in your friendship app data folder). It should show you how to do step 1-3, as far as I remember. I am not sure about your step 4, maybe other users have more experience with this? CheersJoergCOMconnection.fdf Share this post Link to post Share on other sites
Ms. Manuel Ventura 0 Report post Posted July 9, 2015 Hi Joerg Thank you for your quick reply. I am now going to make some tests. Best regardsManuel Ventura Share this post Link to post Share on other sites