Jump to content
Sign in to follow this  

How to display data scraped from a web page?

Recommended Posts



I have written a script which gets the wind speed and direction from a web page once every minute (or 30 seconds). I then want to display it in a window which displays all the previous readings and updates accordingly.

This should be easy I'm sure. But I've tried a few different methods of which none are satisfactory:

1) Writing the data into an untitled - Notepad window. This works fine as long as I'm not using the pc for anything else. In other words, if I am working in another application and typing away, as the script switches to the notepad application, the two get mixed.

2) Using msgBox commands every minute which time out after 50 seconds and are then replaced by a new updated one. But eventually, this becomes too big for the screen.

3) Using SplashText - but this is a fixed size window with no scroll and fills up after less than 20 readings.

4) I've looked at (but not tried) using an 'edit' box in a GUI control but I don't want the box being typed into.

The data that has been collected is just stored in one string. So easy to send to whatever the right display method might be. It just needs to come up on the screen in a scrollable window that can't be edited.

Below is an example of the data scraped:

(Wind Speed is in km/h)

1 - 21:31:54 CalmCalmHigh Gu

2 - 22:08:56 CalmCalmHigh Gu

3 - 22:09:29 SSW 8

4 - 22:10:02 SSW 8

5 - 22:10:34 SSW 5

6 - 22:11:08 SSW 5

7 - 22:11:41 SSW 5

8 - 22:12:14 SSW 5

9 - 22:12:46 SW 11

10 - 22:13:19 SW 11

11 - 22:13:52 WSW 8

12 - 22:14:25 WSW 11

13 - 22:14:58 WSW 11

14 - 22:15:30 WSW 8

15 - 22:16:03 WSW 8

16 - 22:16:36 WSW 8

17 - 22:17:09 WSW 8

There is probably an incredibly simple solution and I'd be very grateful for some pointers in the right direction.


Share this post

Link to post
Share on other sites

There are already some weather applications available on the forum. They might give you an idea how to retrieve the data.

One of them is

You'll find more if you search for "weather wind" etc.

My UDFs and Tutorials:


Active Directory (NEW 2018-12-03 - Version - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki

ADO - Wiki


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this