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

Hi Modano Community,

We have a group of modular financial models that we've built using Modano and, while the core of each is quite standard, there are lots of variations between them in things like categories and drivers and modules, etc. We're trying to find a way of getting some key stats out of each of the models - but a challenge with that is that everything is in different places in each of the different models.

Hi guys

Is it possible to hide sheets with VBA code in modular workbook?

I tried but it throws some error and the code is working with other files.Could you clarify?

See code below:

Sub SwitchToUserMode()
    Dim wks As Worksheet
    For Each wks In ActiveWorkbook.Sheets
        If wks Is ActiveSheet Or InStr(1, wks.Name, "User") > 0 Then
            wks.Visible = xlSheetVisible
        Else
            wks.Visible = xlSheetHidden
        End If
    Next wks
End Sub