Skip to Content
avatar image
Former Member

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

May 15, 2017 at 01:38 PM | 429 Views | Last edit May 15, 2017 at 02:57 PM 2 rev.

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Vadim Kalinin
    May 15, 2017 at 01:46 PM

    "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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Vadim Kalinin
    May 15, 2017 at 03:16 PM

    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

    Add comment
    10|10000 characters needed characters exceeded