Static Web Query Syntax

I am having difficulty with the syntax of the ActiveSheet.QueryTables.Add line of following web query:

Please Login or Register  to view this content.

It is meant to pass values of 4 parameters (date1, date, exch2, expr2) stored in cells B1 through B4 to the web site which will return a table of numbers base on the parameter values.

Note that my web query using this .iqy file works fine:

Please Login or Register  to view this content.

However, I really need a macro to perform a static query using parameter values found in the spreadsheet.

Any suggestions for the macro syntax? Much appreciated.