(Solved) – Can I use VBA to pull data from a secure website and have it populate cells in excel every hour up until a certain hour?

  • by

I don’t have any experience with VBA so the code I have been using has been obtained from other sources (http://dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/).

So far I have been able to use VBA code to log into the website I need to pull the data from, however I have not been able to scrape the data I need with the code I have been using. I have tried various methods such as getElementsByClassName, querySelector, and all.Item(Div id. class id) but to no success.

The full XPath of the data I am trying to pull looks like this:

Could someone please advise how I could go about the above and have it pull into a table every hour?


Leave a Reply

Your email address will not be published. Required fields are marked *