Skip to Content
0

ByDesign Excel Add-in - How to refresh a report using VBA?

May 15, 2017 at 01:38 PM

238

avatar image
Mark Stikvoort

Hi,

I have created an Excel with several ByDesign reports. All works fine. I am looking to create a macro that will refresh the reoports upon click. I have tried to find code examples, but it seems I need a reference library installed first in the VBA editor. However, I cannot find the reference library for the ByDesign Excel add in anywhere, to be able to code a refresh in the macro. I am farily new to SAP as well as VBA, so I might be overlooking very basic stuff.

IS the EPM Excel Add-in the same product as the ByDesign Excel Add-in?

- Mark

SAP Business ByDesign
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sort by:
avatar image
Vadim Kalinin Answered May 15, 2017 at 01:46 PM
0

"IS the EPM Excel Add-in the same product as the ByDesign Excel Add-in?" - No! EPM Add-in is the interface for Business Planning and Consolidation.

Please change tag! Use

SAP Business ByDesign

Show 2 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Mark Stikvoort
May 15, 2017 at 02:58 PM

I updated the Tag. Do you also have an answer to my main question perhaps?

0
Vadim Kalinin
Mark Stikvoort
May 15, 2017 at 03:02 PM

Unfortunately I can help only for EPM Excel Add-in and BPC related things...

0
Comment
avatar image
Vadim Kalinin Answered May 15, 2017 at 03:16 PM
0

May be this discussion will be helpful (look on the code attached in the comments):

https://archive.sap.com/discussions/thread/3763467

code:

https://archive.sap.com/attachment/444238

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users