API

Hi Guys,

We've had some of our more advanced users ask if there's any way to automatically align the time series assumptions of multiple modular workbooks that are not located in a linked workbook project, and thereby prevent the need to manually open each workbook and enter the time series assumptions.

The most common example of this scenario is when users are working with multiple related modular workbooks, but have chosen not to include them in the same project for practical reasons, such as ease of independent distribution and use.

Hi, 

I have been using the Modano API to automate the production of PDF report from a Modano active model. 
Everything works fine until I tried to have different no of column hidden in time series sheet. It seems to apply the hiding of column to all time series sheet with the same time hierarchy (i.e. hiding column J in 1 annual time series sheet will cause all column J to be hidden for all annual time series sheet in the model).

Is there a way to customize the number of columns hidden using the API for each individual time series sheet?

Thanks

Hi Everyone,

This is my first post in here.

Is there any quick/easy way (VBA even) to obtain a list of the version numbers of every module within a modular workbook?

Other than going into the Project Manager and manually noting them down.

Thanks.

Hi,

I have been working on a workbook that contains Macro for hiding columns with Modano active. 

I understand that Modano has password protection to prevent unwanted changes in the formula and formats but this has caused my code to break every time I re-open the workbook.

Is there any way to get around this without releasing the workbook?

Attached is a screenshot of the error that I got every time I run the code right after I open the workbook. 

Thanks