Data from Web page using option "From Web" from Data menu!

[Monty]

Hello Everybody.

Strange question, we can web scrap by using data menu and clicking on data from web to get the text from web page to excel made so easy.

But what if web page consists of check boxes with selections can we get only selected check boxes information from web page to excel.

Tried getting this but end up with getting all check boxes information rather then getting only selections.




Monty!

 

[Marc L]

Hi !

Data Frow Web use QueryTable VBA object to load a HTML Table
or all tables from wepage or all content of webpage,
but not works on all webpages …
​

 

[Monty]

Mark.

.It's really a great feature in excel... Unfortunately apart from importing static data...We can't do much for check boxes /option buttons selection capturing...
How about web scraping technique?
Monty

 

[Marc L]

Maybe like for any object from DOM …​

 

[SirJB7]

Hi, Monty!
Any URL as example?
Regards!

 

[Monty]

Hello Sir Bj....Am using intranet site which our company based portal...

 

[SirJB7]

Hi, Monty!
Any other URL as example? I don't remember right now any with those characteristics.
Regards!

 

[Monty]

Hello Sir.

Am not really sure sorry...need to have some web page where the user had selected some checkboxes.

Monty!

 

[SirJB7]

Hi, Monty!
Just update this thread if you happen to find one alike.
Regards!

 

[Monty]

Sure Sir