Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Can anyone provide some advice as to why the line marked "ERROR" below results in a Run-time error 91? I know it relates to .elements(nm).Value. I've successfully tested to see if I can hard-code the name and debug.print the value. However it won't accept a built-up string (nm). Sub Test() Set IeApp = New InternetExplorer IeApp.Visible = True IeApp.Navigate "http://www.mywebsite.com" Do: Loop Until IeApp.ReadyState = READYSTATE_COMPLETE With IeApp.Document.forms("form") For Each cell In rng nm = "rates[" & cell & "]" cell.Offset(0, 1) = .elements(nm).Value <== ERROR Next cell End With End Sub Many thanks in advance if anyone can provide some advice. Regards, Chris Adams |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Internet Explorer | Excel Discussion (Misc queries) | |||
internet explorer instance | Excel Discussion (Misc queries) | |||
error in script from internet explorer | Excel Discussion (Misc queries) | |||
Interaction with Internet Explorer | Excel Programming | |||
internet explorer | Excel Discussion (Misc queries) |