I am trying to get data from a web app which creates a table.
When I try the "get data" function on excel it doesn't "see" the table, it sees an empty page as far as I can tell.
What I want to do is for an excel sheet to go in every day at a certain time (which i saw can be done with the windows tasker) and run a macro which takes the column of data for "today" and adds it in a new column into the spreadsheet.
The website for the web app is: " the system is not allowing me to put the link until i post a few times"
The website that launches the web app is: **again, the system doesn't allow me to post the link** The information is for the fire danger rating in British Columbia Canada, for the northwest fire centre
***you need to click on one of the "Danger class report" at the bottom of the page, I click on the Northwest fire centre.
Once I have this data I need to apply certain scenarios to it for warnings to pop up. But first I need to be able to auto update the data.
Thank you in advance!
Bookmarks