Run-Time Error 91 for Internet Explorer .elements(name).value
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
|