Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get data from Internet? XML? QUERY?
If you read my post below I'm trying to figure out how to get some data from a weblik and post the results in excel. The original code using XmlImport worked fine but won't work in older version of excel "2000". I've been able to get
Application.Worksheets("WORKSHEET").QueryTables.Ad d to work but I can't figure out how to paste the daat into an array isntead of on the worksheet. Is there an easier way to try and do this? I need to extract the Latitude and Longitude for a give location. http://geocoder.ca/?stno=75&addresst=Spring Street&city=Almonte&prov=ON&postal=K0A 1A0&decimal=6&geoit=XML |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Web query failing due to too many temporary internet files? | Excel Programming | |||
Pasting a URL or search info unto EXCEL Internet query | Excel Worksheet Functions | |||
Internet Query? | Excel Worksheet Functions | |||
Help with updating query table from internet | Excel Programming | |||
geting data from internet | Excel Programming |