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