Thursday, July 03, 2003 :::
 
Updateable LInks in Excel

-Open Excel.
-Design the document as you wish it to appear.
-Select the cell where you want the weather information to begin.
-Click Data | Get External Data | New Web Query.

-In the first field ("Enter the address..."), enter http://www.weather.com/outlook/travel/print/33755, replacing the 33755 with the ZIP code for the area for which you desire a forecast.

-In the second field ("Choose the part of the web page..."), select the option button for "Only the tables."

-In the third field ("Choose how much formatting..."), select the option button for "None." Click OK.

-In the "Returning External Data to Microsoft Excel" dialog box, confirm the location where you want the information to start appearing. Click "Properties." Maintain the selections for "Save query definition" and "Enable background refresh," and select "Refresh data on file open." Deselect "Adjust column width" and "Preserve cell formatting." Finally, select the option for "Overwrite existing cells with new data, clear unused cells." Click on OK.

-In the "Returning External Data to Microsoft Excel" dialog box, confirm the cell where you wish to begin inputting the information. Click OK.

-Once the information has been imported, you'll need to delete just a few cells containing unnecessary data.

-Save the spreadsheet and you're good to go. The next time the file is opened, the most current information from weather.com for the indicated ZIP code will be placed where you indicated.
"I know many people aren't accustomed to using Excel as a surrogate desktop publishing tool, but I find it offers me more control over the placement of the various elements than Word."

::: posted by Muhammad at 7:24 AM

ARCHIVES :::

These are some of the problems and solutions at the IT Support Desk.