How can I pull the data next to a name from a website in VBA?

Originally Posted by JeanRage

Hi,

Have you picked which way to go : the web query route or the HTML object route ...
Posting your actual code would certainly help ...

I'm not sure what you mean. This is the relevant piece of the code. H
D

eclare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

Public ie As Object

Sub RedLobster()
  initializeIE True
  ie.navigate "https://gift.redlobster.com/GiftCard/Balance.aspx"
  waitForLoad
  saveFile ThisWorkbook.path & "\redlob.html", ie.document.all(1).outerHTML
  ie.document.all("ctl00$ContentPlaceHolder1$ctl00$txtGCNumber1").Value = "1234"
  ie.document.all("ctl00$ContentPlaceHolder1$ctl00$txtGCNumber2").Value = "5678"
  ie.document.all("ctl00$ContentPlaceHolder1$ctl00$txtGCNumber3").Value = "9876"
  ie.document.all("ctl00$ContentPlaceHolder1$ctl00$txtGCNumber4").Value = "5432"
  ie.document.all("ctl00$ContentPlaceHolder1$ctl00$btnCheckBalance").Click
  waitForLoad
  saveFile ThisWorkbook.path & "\redlobbalance.html", ie.document.all(1).outerHTML
  'What would I put here to save the balance or other info off the site?
  
End Sub

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

https indicates a secure site, I doubt if you will be able to access any data without the relevant log in.

Why would you want to do this?