on 12-08-2013 7:08 PM
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!!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.