Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi have been using a dump routine posted by Joel to ascertain the reference
for objects in several web pages including three for mileage calculation. Am unable to return the mileage by road output from the following web page, URL = "http://www.freemaptools.com/distance-between-uk-postcodes.htm" am sure the reference is : Set dis = IE.document.getElementsByTagname("INPUT") Set distance = dis.Item(7) Worksheets("sheet1").Range("a1") = distance.innertext but get no value returned from this! Should I be using a different suffix other than "innertext"? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referencing two versions Object models | Excel Programming | |||
Referencing Object Names with Variable | Excel Programming | |||
Referencing worksheet CODENAME in a chart object. | Excel Programming | |||
Re referencing an object | Excel Programming | |||
Referencing a ComboBox control from a Workbook Object? | Excel Programming |