(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
(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?

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:
/html/body/div[2]/div/div/div[1]/div[2]/div[1]/div[2]/table/tbody/tr/td[2]

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

Thanks

Leave a Reply

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