About Web Page Data Receiving to Access

[notrino]

Hello,

I have a small measurement system at home and it works like a server. So when you connect to the device with IP no, you can see the values of CO2, Humidity, Temperature of the home environment on the web browser. I'm sending the Html codes of the page in the appendix. In these codes, you can find CO2, temperature, humidity texts. My goal is to be able to see these values momentarily in the boxes in the attached simple Access file. (Note: the web page itself is a refresh of 10s, Html page looks like, I gave the code to Share Point Designer with copy-paste you can see.) Thanks ..

[June7]

I have no idea what your Note means.

Possible options:

1. display page in Internet Browser control on a form.

2. CDO code for internet browser - search web for example code to scrape webpage
I can get code to open your html in web browser, but nothing beyond that.

[notrino]

Hi June,

My server working like Weather Station. In this way, I can see the temperature -humidity values from web browser. The device has a IP number and if you write that IP number to the web browser you can see the on-line temperature-humidty values. I sent that html codes, you can see where is the temperature humidity expression on that html file. In this way, I want to take tahat values from that web site to the Access text box. I don't know is it more clear now?Thank you..

[June7]

I understand what you want, I just can't get scraping code to work with the text file you provided, possibly because it is not an http web page that opens.

I found example code that shows how to reference html <td> cells but your html is not coded that way. https://stackoverflow.com/questions/...site-using-vba