cancel
Showing results for 
Search instead for 
Did you mean: 

VBA API - OpenExcelWorkbook not working

Former Member
0 Kudos

Hi Experts

I wanted to open other report from current report using button on excel which will be assigned to below API

Sub open_other_report()

Var1.OpenExcelWorkbook ("\REPORTS\REPORT_7.xlsm")

End Sub

While debug it gives error ->

Tried with different path but still giving error ,, also tried with wizard folder still not working..

I knew EPMlink() function but it need double click.

Thanks!!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

As far as I know, this is not possible from VBA. This specific API will look for the link you provided on the local machine of the user, not in the BPC server root folder.

In excel, you can use the EPMPathLink functionality:

=EPMPathLink("<Model Name";""\REPORTS\REPORT_7.xlsm";"Text to display";"Context open")

This will however require a double click, but maybe you can create vba in a button, to do a double click on the cell where you have put the formula.

With kind regards,

Tim

Former Member
0 Kudos

Hi Tim

Thanks for your reply !!

Answers (0)