Forum Discussion

vasantharaidu's avatar
vasantharaidu
New Contributor II
2 years ago

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. 
Spreadsheet
  • JackLacava's avatar
    JackLacava
    2 years ago

    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.

JackLacava's avatar
JackLacava
Honored Contributor

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.

vasantharaidu's avatar
vasantharaidu
New Contributor II
2 years ago

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.