Skip to main content
Member
Mar 30, 2023 12:48 PM UTC
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. 

Employee - Sage
Mar 30, 2023 3:13 PM UTC

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.

2 replies

Employee - Sage
Mar 30, 2023 3:13 PM UTC

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.

Member
Aug 9, 2023 6:57 PM UTC

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.