Hey there,
So I am trying to extract data using a basic web query to dump it into a garbage tab to refer to the data in other tabs. However, the websites I try to query demand me to specify a start and end date or to press a button. The URL does not change at all. This challenges me big time as I fear that the solution requires knowledge about non excel related coding languages.
https://gasdata.fluxys.com/sdp/Pages/Reports/BalancingInformation.aspx
On this website I need to press the load data button. Afterwards I can do everything myself using unsophisticated and dirty methods. If just I'd be able to teach excel how to press the button
SIMEE - OPERATIONAL DATA
On this website I need to change the month and then press the arrow. Same story as above. Once I overcome these issues I'll use simple methods to digest the data.
What I managed to do with my abilities:
- standard web query
- open and copy files from online xls file via VBA automatically
- manipulate a dynamic URL including start and end date via VBA automatically
Thank you in advance. All assistance is much appreciated. And don't shy away from posting dirty fixes, I'll probably understand them quicker anyway
So I am trying to extract data using a basic web query to dump it into a garbage tab to refer to the data in other tabs. However, the websites I try to query demand me to specify a start and end date or to press a button. The URL does not change at all. This challenges me big time as I fear that the solution requires knowledge about non excel related coding languages.
https://gasdata.fluxys.com/sdp/Pages/Reports/BalancingInformation.aspx
On this website I need to press the load data button. Afterwards I can do everything myself using unsophisticated and dirty methods. If just I'd be able to teach excel how to press the button
SIMEE - OPERATIONAL DATA
On this website I need to change the month and then press the arrow. Same story as above. Once I overcome these issues I'll use simple methods to digest the data.
What I managed to do with my abilities:
- standard web query
- open and copy files from online xls file via VBA automatically
- manipulate a dynamic URL including start and end date via VBA automatically
Thank you in advance. All assistance is much appreciated. And don't shy away from posting dirty fixes, I'll probably understand them quicker anyway
