Data Scraping from the WebSite

Hi,

Web scraping from the following site fails to get data

http://www.religareonline.com/resear...arch-reports/4

Anything iam really missing or missing the Element ID

Sathis

Please Login or Register  to view this content.

I do not know what was the expected output, but the code seems to work and get some data. See attached.

Originally Posted by AB33

I do not know what was the expected output, but the code seems to work and get some data. See attached.

Hi,
Thanks for the Reply,
The data below the headers (All report,.........) need to be queried.

Any Insights.

Sathish

@JAsperD, will look into your version more in details, looks interesting...

Alternatively, using Internet Explorer for scraping seems to work in this case...

For instance, try:

Please Login or Register  to view this content.

where the output will be stored a new sheet; Col.A contains report name w/ hyperlink, Col.B date, Col.C description.

Cheers,
berlan

Jasper and Berlan,
I suspect the OP is looking to download the data embedded with in JAVA and PDf file, not simply the data on the body of the page.
I am unable to run Jasper's code as VBA keep tells me "Active component can not create object" despite I am connected to the Script control (Ticked). I am sure there is something missing from my reference library.

Hi,
Thanks again for your reply.
I was struggling for the code for the past 3 days and it worked.
You are doing great.

Sathis

Originally Posted by JasperD

You're looking for something like this:
Set reference to Microsoft Scriptcontrol

Please Login or Register  to view this content.

As always - props to Kyle123 for originally coming up with this

Hi,

Thanks for your reply
Your code works like a charm.
Sathish

Originally Posted by berlan

@JAsperD, will look into your version more in details, looks interesting...

Alternatively, using Internet Explorer for scraping seems to work in this case...

For instance, try:

Please Login or Register  to view this content.

where the output will be stored a new sheet; Col.A contains report name w/ hyperlink, Col.B date, Col.C description.

Cheers,
berlan

You're welcome, and thanks for the feedback!

Hi,

Web scraping from the following site got error , while using the following code.

Need your help to resolve.

Please Login or Register  to view this content.

Hi,

change,

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

or feel free delete the whole loop for adding hyperlinks..

Cheers,
berlan