Passing parameters to a Web Query

[Raymond D'Anjou]

I'm not an Excel expert so bear with me.

I want to create a Web Query but I want to pass parameters from the
Worksheet itself...
Something like this:

http://webSite/somepage.asp?startDate=summary!a1&endDate=summary!b1

Essentially, my ASP page needs a start and end date to pass to an SQL stored
procedure.

Is this even possible and if not, do I have any other options?

 

[Raymond D'Anjou]

Took me a while, but I found how to do this.