VBA and IE: how to change the ClassName of a Table

[AymericA]

Hello!
I am using VBA and Excel to extract some data of a website.
My problem is the following. Data appear in a table only if its class indicates " " rather than ""is-user"

<table id="tableID" className="is-user">

I have no issue identifying this table as it has an ID.
How can I change that ClassName using a VBA function?

Thanks.

 

[Marc L]

Hi,​

​

as you read the data you do not need to modify the source webpage code ‼ ​

​

If the ID is unique you even do not have to search for any class name but obviously just the ID …​

 

[AymericA]

Thanks Marc.
I am not allowed to read the data if the table classname is "is-user". They do not appear on screen and my VBA script is blocked.
If I change that classname to "" (in the source code), then I can see the data on screen and my script can access the data.
Is it possible?

 

[Marc L]

​

Same answer : if the ID is unique …​

 

[AymericA]

sorry Marc. I think I am not clear.
I do not need to find that table. Thanks to the ID, as you say, it is easy to find.
Once the table is identified, I would like to change the classname in the source code.
Still the same answer?

 

[Marc L]

​

So once you have found the object with its ID, what happens with its property 'classname', what did you attempt ?​

 

[AymericA]

for the moment, I have in the webpage source code <table id="tableID" className="is-user">
and when I change it to <table id="tableID" className=""> directly in the source code then my script works.
is there a VBA script to change this property 'classname' ?

 

[Marc L]

​

object.className = "" where object refers to the found ID and if only you are granted to modify the source webpage code …​

 

[AymericA]

as simple as that...
and it works perfectly.
Thanks Marc