Solved

How to use external macro after refresh workbook in forms template

We are trying to create a form with external vba code to refresh automatically once the onestream addin- refresh workbook.

Best answer by JackLacava

That's really an Excel question... as far as I know, there is no facility in the add-in to do that sort of thing.

You might have better luck by implementing your own "refresh" routine, that first calls the add-in function and then executes its custom bits.

That's really an Excel question... as far as I know, there is no facility in the add-in to do that sort of thing.

You might have better luck by implementing your own "refresh" routine, that first calls the add-in function and then executes its custom bits.

Hi Jack,

Thanks for your idea, i have created a code to call Onestream addin refresh, along with vba code to run based on Onestream workflow data.

Thanks for your spark on this.

Sign up