Author: Pete73 | Posted on: 7/8/2009 5:24:47 AM | Views : 283

 I have been searching all over the internet looking for information on extracting a query string value into an xls so I can filter the data. I am brand new to xml and my knowledge is very limited. Below is what I currently have...
In my xls that displays the webpage I have the following:
<a href="mapname.aspx?ObjectID={ObjectID}&amp;Lname={LastName}">Map this address</a>
this part works fine and calls my mapname.aspx page with the correct object id and last name.
problem I have is how do i extract these so I can use them to send to another xls stylesheet that returns only the node I am interested in...
 
I know the following code works in java script:
var aNameValuePair = location.search.substring(1,location.search.length).split("&");
   var aParam = new Array(aNameValuePair.length);
   for ( var i=0; i<aNameValuePair.length; i++ ) { Go to the complete details ...