Web scraping in edge (1 Viewer)

[Joy83]

Hi,
Can you help me to find a code that scrape through a web page using edge browser.

along with the needed libraries to do this..

Thanks a lot

 

[arnelgp]

what info do you need to scrape?
have you tried to use Power Query of Excel, it can extract data from a URL. (website).

 

[Joy83]

I actually have a code in access and I want to embed the scraping inside to fill something in the dasanase.
I just need the text inside. The format doesn’t matter. I just want the string

 

[arnelgp]

what values are you "scraping"?
does it requires you to enter a password?

i did web scraping before (currency exchange rate).

 

[Joy83]

thanks for your reply
Table that consists of some text information
It doesn’t have a password

can you please share the code

 

[arnelgp]

you can download it here:

Exchange Rate/ currency conversion

this is a simple program that will convert 1 US dollar to any currency. it gets the data from http://www.floatrates.com/daily/usd.xml. the old method (Internet Explorer application) will not work on Win 10/11. therefore this db is modified to use XMLDocument to get the data. there are two subs...

www.access-programmers.co.uk

 

[Joy83]

you can download it here:

Exchange Rate/ currency conversion

this is a simple program that will convert 1 US dollar to any currency. it gets the data from http://www.floatrates.com/daily/usd.xml. the old method (Internet Explorer application) will not work on Win 10/11. therefore this db is modified to use XMLDocument to get the data. there are two subs...

www.access-programmers.co.uk

I really thank you soooo much for your reply
This is exactly what I am looking for

I need one favor from you
I can’t download the attachment in my device
Can you kindly copy the code for me.
And the libraries that are needed

this will be a great great help from you

 

[arnelgp]

the code exceeds the limit of 1000 lines.

 

[Joy83]

the code exceeds the limit of 1000 lines.

Thanks a lot

for some reason the source didn’t copy well.

i noticed that the page is using asp

do you think there is another way to do it

 

[jdraw]

You may get some insight from Paul Kelly's latest video on web scraping.

 

[arnelgp]

you may download it here.

ExchangeRate2.accdb

Shared with Dropbox

www.dropbox.com

 

[arnelgp]

do you think there is another way to do it

if you can't download, maybe you can upload your db.