Establish your queryrecord a refreshintroduce your parameters into the
macro. If you can't figure it out send your wb to my address with complete
details and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Hemant Oswal" <Hemant wrote in message
...
i want to execute such a web query for which i am setting parameters in
that
query.
I want to change parameters through visual basic script progrram and
refresh
data.
how to do that programming.