Embedded macro returns error when started by green traingle, but runs when started from script window
Apr 28, 2020 6:05 AM(1348 views)
I've embedded a macro into my data table. But when clicking the green triangle, it gives me the following error message:
"Unresolved ColumnException in platform launch in access or evaluation of 'Control Chart Builder' , Control Chart Builder(/*###*/Size( 300, 275 )"
I believe it has to do with the specified size of the graph, however, when I open the script by clicking on "edit", then run it by clicking "run" from the script editor window, it does work, without error message, and returns the desired results.
I should add: when triggered with the green triangle, the macro runs OK past the date picker, and even spits out graphs (despite the error messages). But they are greyed out in the window list and the graphs are empty (see screenshots attached). When triggered from the script window, the macro returns the graphs as desired.
result graph script windowresult graph green trianglegreyed out graphs