Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Run Macro on Refresh Not Saving

Hello,


I recently generated a macro in a module for a BEx workbook that has a query setup to "Refresh Workbook on Open".  Ideally I want this macro to execute on each Refresh.  After searching google I came across this linked article.

I then went into Workbook Settings opened the "Exits" tab and clicked on "Run Macro on Refresh".  I input the name of my subroutine from the recently added module.  On my macro I added "ParamArray varname()" as a parameter (ie: Sub CopyFormulas (ParamArray varname())    ).

When I test it and repull in data through "Change Variable Values" it seems to work.  My sub is called and appears to be working.  I then use the BEx save workbook option, but when I close and re-open my workbook the "Run Macro on Refresh" toggle is off and my macro name not listed.

Any help to resolve this issue would be greatly appreciate.

-Jon

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question