Log on to BPC 7.5 MS via VBA?

[victor_sales]

Hi Community,

We have some maintenence functions in VBA to save some selection reports to improve the user experience improving the waiting times.

The issue is when we want create a windows schedule task to execute periodically this maintenence functions because sometimes the server was restarted and the session has expired.

Is it possible to log in to BPC OsoftAddIn automatically via VBA macro?

After that will be easy execute the other functions.

Thanks in advance!

Victor

[former_member186498]

Hi Victor,

add the following lines on Thisworkbook folder (verify the path of the specified file)

Private Sub workbook_open()

     Application.Workbooks.Open ("C:\Program Files\BPC\Ev4Excel.xla")

End Sub

Regards

     Roberto

[victor_sales]

Thanks Roberto but this function is used to open any file excel offline.

We try to know what function in VBA through libraries OsoftAddin allows us to connect to BPC just open workbook.

Regards

Victor