Execute a macro with XL Reporter

[Former Member]

Hello,

I'm creating a report using XL Reporter. I wish I could automatically run a macro at the end of the data import.

Can someone indicates me where I have to insert my VBA code in the report designer ? (Workbook, Sheet, Module...)

[former_member186095 · Accepted solution]

Hello,

try to do this :

In ecxel menu

1. choose tools --> macro --> macros

2. Select macro called "xlr_reportcomplete and choose edit

3. copy the macro'sentire code from where it says "sub xlr_reportcomplete()" to where it says end sub

4. In the project - VBAProject window pane, go to MS Excel Objets and double click the object, sheet1 (name of the sheet), a blank code window is opened.

5. Paste the code that you copied into the balnk window and close the MS VB editor

7. save the report definition.

Let me know the result if you still can't solve.

Rgds,

[Former Member · Accepted solution]

Thanks !

I had tried to wrote my macro in a distinct module and it didn't work.

With the macro in the good sheet object, it runs perfectly !

Guillaume