Object doesn't support this property or method runtime error in vba

Question

I am encountering an

Object doesn't support this property or method

Runtime error in excel vba.

Note : The code works fine in my laptop.This error happened when I migrated the code to my desktop pc.

Below is the UPDATED code.

Dim ie As InternetExplorer

Dim htmldoc As MSHTML.IHTMLDocument

Dim ro1 As MSHTML.IHTMLElementCollection

Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = False

ie.navigate "url"

Set htmldoc = ie.document

Set ro1 = htmldoc.getElementById("table id").getElementsByTagName("tr")

ThisWorkbook.Sheets(1).Cells(k, j) = rows(k).Children(0).textContent

ro1(k).Children(0).textContent is the error part.

I have checked Tools->References. Microsoft Internet Controls and Microsoft HTML Object Library has been checked.

Can anyone please guide me for this ?

Start by adding a line Option Explicit at the top of your module, and then Debug->Compile to identify variables and objects that aren't properly declared or are being misused, Keep compiling until no more warnings. — ashleedawg
– ashleedawg, Commented Dec 28, 2017 at 10:58
What is rows(k).Children(0)? Run in Immediate Window: ?TypeName(rows(k).Children(0)) — JohnyL
– JohnyL, Commented Dec 28, 2017 at 11:00
@user3126632 I only replaced rows(k).Children(0).textContent with rows(k).Children(0).InnerText. Did you try that? — Subodh Tiwari sktneer
– Subodh Tiwari sktneer, Commented Dec 28, 2017 at 11:30
@sktneer That's the answer.Replaced textContent with InnerText .Please post as answer with needed explanatiion — user3126632
– user3126632, Commented Dec 28, 2017 at 11:51

Subodh Tiwari sktneer · Accepted Answer · 2017-12-28 13:10:45Z

1

Try using InnerText instead of textContent and see if that works for you.

ThisWorkbook.Sheets(1).Cells(k, j) = rows(k).Children(0).InnerText

answered Dec 28, 2017 at 13:10

Subodh Tiwari sktneer

9,9862 gold badges20 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ashleedawg · Accepted Answer · 2017-12-28 11:06:58Z

0

Start by adding a line Option Explicit at the top of your module, and then Debug->Compile to identify variables and objects that aren't properly declared or are being misused, Keep compiling until no more warnings.

Also, don't use the word ROWS as an object name. Rows already means something in Excel & VBA.

Here is a list of reserved words that should be avoided. (I realize it's labelled Access 2007 but the list is very similar, and it's surprisingly difficult to find an recent 'official' list for Excel VBA.)

answered Dec 28, 2017 at 11:06

ashleedawg

21.9k9 gold badges82 silver badges120 bronze badges

5 Comments

user3126632 Over a year ago

I replaced rows with ro1.But that is still not serving the purpose. Note : Code runs fine on my laptop.

ashleedawg Over a year ago

you replaced all occurrences iin the project? Aldo did you add Option Explicit to all modules in the project?

ashleedawg Over a year ago

ok so did you declare htmldoc ? Or is that declared elsewhere in code that wasn't shared?

user3126632 Over a year ago

Dim htmldoc As MSHTML.IHTMLDocument is declared in the code.

ashleedawg Over a year ago

okay, not in the code you shared. Also I don't see a target URL being assigned to an object. What page is this trying to open? Also what is the value of k and j? This would be much easier with all of the related information.

Collectives™ on Stack Overflow

Object doesn't support this property or method runtime error in vba

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related