JimS
09-24-2012, 11:09 AM
I’m running Excel 2007 with PI Datalink 4.2. I have created a form that allows the user to select the different tagnames that they would like to see their historical data for. VBA then takes these tagnames and pastes them into the appropriate cells that the PI Datalink Sample Data Field (PISampDat) needs them to be in.
I’m using a dynamic range name that references all the tagnames selected by the user.
My issue is that the Sample Data Field converts the dynamic range to its the absolute range (ie $A$1:$D:$1). It loses the dynamic functionality.
Does anyone have a way to get around this? Is there a way that VBA can set the Tagname field in Sample Data form? Or, is there a way to make it so Sample Data stops converting my dynamic name ranges into absolute cell references?
Thanks for any and all help...
JimS
I’m using a dynamic range name that references all the tagnames selected by the user.
My issue is that the Sample Data Field converts the dynamic range to its the absolute range (ie $A$1:$D:$1). It loses the dynamic functionality.
Does anyone have a way to get around this? Is there a way that VBA can set the Tagname field in Sample Data form? Or, is there a way to make it so Sample Data stops converting my dynamic name ranges into absolute cell references?
Thanks for any and all help...
JimS