5 Replies Latest reply on Jan 24, 2012 9:33 AM by R. S.

    Non-static "global variable"?

    R. S.

      I’m looking for something that has the functionality of a Parameter, but I need the value of the Parameter to not be static.  I have multiple workbooks where I make http calls to a web server that sends back images to the workbook.  In those calls I use a token to help secure the whole process.  The token comes from a live secondary data source and I currently store it in a Parameter so that I can use the value anywhere in the workbook.  My problem is that the token is changed frequently, but Parameters do not update automatically.  I have to manually reset them.  This is not convenient, especially over multiple workbooks.  Is there a way to designate a ‘live’ global variable like this?  I'd also be interested in a totally different way to approach this.  Thanks!!