Passing parameters to a Web Query
 

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?startDat...e=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?

Passing parameters to a Web Query
 

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

"Raymond D'Anjou" wrote in message
...
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?startDat...e=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?