Executing Subroutine from Load script

[Anonymous]

Hello,

I have a subroutine and several functions, which I have coded in the Edit Module window. The subroutine follows the below format: 

SUB exportToExcel_v2

     [Code

           ...

           ...

           ...

           ...

     ]

END SUB

While I am able to assign this subroutine to a button, and have the subroutine execute when a user clicks on the button, I wondered if there was a way to have the subroutine automatically execute when a user Reloads the LOAD script?

I have been trying to find a solution online and in the reference manual, but I cannot seem to find a concrete answer.

I would really appreciate any assistance with this issue.

[trdandamudi · Accepted solution]

May be this:

Go to

Setting-->Document Property-->Trigger-->Select On Post Reload-->Click on Add Button on right side

then add Action as Run Macro --> YourMacroName

[Anonymous]

This was exactly what I was looking for--adding a reload 'Trigger' had not crossed my mind.

Thank you!

[krishnacbe]

Hi,

Please try executing the script below using button event trigger to reload()

LOAD *;
SQL EXEC [SubRoutine Name];

Regards

Krishnapriya