- Setting up a New Web Query in Excel 2002

Setting up a New Web Query in Excel 2002

After opening the Web Query dialog box shown below, you will see a browser window.

This is the web page that Excel is going to look for to open up HTML tables and update the Excel

tables. Now, either type in the URL of the application or use copy and paste. This will open up the

application but without the operation or table that you want. Now append the Operation ID

recorded earlier to the URL.

The web query should now be of the following form:

xx is the id of the application while yy is the id of the operation. For this example we use:

Now press enter and the operation should show up in the web query screen. There will be little yellow

arrows around the page representing the location of various html tables. Select the one containing your

desired data. A green check-mark will appear to indicate you have selected a particular table. Press

import to proceed.

Excel will then return an import data screen with the option to either create a new worksheet with the

data from WOW or put it in current worksheet. Pick the option suitable for your situation.

After selecting the data location, Excel will momentarily say “getting data” and then display the WOW table

information in an Excel table like shown.

By using a right click anywhere on the imported data, options such as refresh values, edit query information,

or edit range options are available.