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

[Former Member]

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

[former_member186338]

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

[former_member186338]

"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

[Former Member]

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