Launch Web Query from Macro

[Anil Kripalani]

Is it possible to have a macro launch the Web Query dialog with it set to a
particular URL? We want to provide our users a button to click that brings
up the web browser UI without having to add in a new web query and enter the
URL. Alternately, we could add one in, erase the cell contents, and get
them to right-click a cell and select Edit Query - even then a button would
be cleaner.

Also, once the dialog is launched we would like to (programmatically) 1)
Turn off the yellow arrows, 2) Set the size (Size of window is kept while
Excel is open, but not when it's restarted).

Any thoughts would be appreciated.

Thanks,
Krip

 

[Anil Kripalani]

R,

Thanks for the code snippets, but I need to launch the Web Query dialog -
the user needs to provide criteria for the query results on the first page,
then the results are shown which are imported into the spreadsheet. So, I
do not know the parameters for the URL until the user picks items from a
list on the web page.

One idea we have is to launch a web browser from within Excel (apart from
Web Query) for the user to make his selections; extract the URL, and feed
that to Web Query as a full URL for import (So that we don't need to bring
up the Web Query UI.)

-Krip