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. 

  • 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

      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.