Retrieving addin data
 

I am trying to retrieve data from an OSI PI database when a form button is
pushed. The addin sets the cell to: =PIArcVal("STSRV_KW",A1, 0,"ABCDE","auto")
Since it will loses its value if not on the company network I want to put it
into a macro, but no matter what I do I get a variable not set error.
Any ideas?