JShelb
03-19-2008, 11:19 AM
Hello all,
I've been stalking your site for sometime now and usually am able to search enough to find what I need or the boost I need to get me in the right direction. However, I've came to a crossroads and am unable to push past this problem. :banghead:
A little background, I'm nub in programming overall, but I have most of my knowledge in vb.net. I have some scripting, html, and vba experience, but not a lot. I believe I read the logic and code decent enough to understand, I just have the problem of knowing what methods there are and what a lot of the methods do. :think:
To the issue:
I have an excel spreedsheet that I record daily numbers/tasks on; like a check-off sheet for the day. I've successfully automated a decent amount of it via buttons, file streaming/reading/searching, links, etc. However, the point I am at now is populating a few cells (6) with data gathered from 6 separate websites. My plan was to create a button for each device and OnClick surf to the site, parse the html for the 3 bits of data, and plop the data into the defining cells. So far, I have successfully navigated to the site and well, that's it, :rofl: .
Code I have:
Private Sub CommandButton1_Click()
Dim ie As InternetExplorer
Dim temp As String
Set ie = New InternetExplorer
ie.Navigate ("IP_Address(Private)")
ie.Visible = True
Do Until ie.ReadyState = READYSTATE_COMPLETE
DoEvents
Loop
temp = ie.Document.all("deviceInfo.tempF").Value
End Sub
Attached is a sample of the html code. Specifically, I'm looking for the values of: deviceInfo.tempF=74.8 & deviceInfo.humid=36.9
I only want the numbers, nothing else, placed into certain cells.
Thank you in advance for any assistance. I'll try to be as helpful as I can and provide any details I can muster up. The site is on a private intranet, so it will be unviewable. Sorry if this is too long.
Jason
I've been stalking your site for sometime now and usually am able to search enough to find what I need or the boost I need to get me in the right direction. However, I've came to a crossroads and am unable to push past this problem. :banghead:
A little background, I'm nub in programming overall, but I have most of my knowledge in vb.net. I have some scripting, html, and vba experience, but not a lot. I believe I read the logic and code decent enough to understand, I just have the problem of knowing what methods there are and what a lot of the methods do. :think:
To the issue:
I have an excel spreedsheet that I record daily numbers/tasks on; like a check-off sheet for the day. I've successfully automated a decent amount of it via buttons, file streaming/reading/searching, links, etc. However, the point I am at now is populating a few cells (6) with data gathered from 6 separate websites. My plan was to create a button for each device and OnClick surf to the site, parse the html for the 3 bits of data, and plop the data into the defining cells. So far, I have successfully navigated to the site and well, that's it, :rofl: .
Code I have:
Private Sub CommandButton1_Click()
Dim ie As InternetExplorer
Dim temp As String
Set ie = New InternetExplorer
ie.Navigate ("IP_Address(Private)")
ie.Visible = True
Do Until ie.ReadyState = READYSTATE_COMPLETE
DoEvents
Loop
temp = ie.Document.all("deviceInfo.tempF").Value
End Sub
Attached is a sample of the html code. Specifically, I'm looking for the values of: deviceInfo.tempF=74.8 & deviceInfo.humid=36.9
I only want the numbers, nothing else, placed into certain cells.
Thank you in advance for any assistance. I'll try to be as helpful as I can and provide any details I can muster up. The site is on a private intranet, so it will be unviewable. Sorry if this is too long.
Jason