LAN Temperature Monitor Visual Basic XML read example code

 

 

 

LAN DS18B20 High-Precision 1-Wire Digital Temperature Monitor

 

 


Private Sub CommandButton1_Click()
Dim strTargetFile As String
Dim wb As Workbook

     Application.ScreenUpdating = False
     Application.DisplayAlerts = False
     strTargetFile = "http://192.168.1.199/status.xml"
     Set wb = Workbooks.OpenXML(Filename:=strTargetFile, LoadOption:=xlXmlLoadImportToList)
     Application.DisplayAlerts = True

     wb.Sheets(1).UsedRange.Copy ThisWorkbook.Sheets("Sheet1").Range("A5")
     wb.Close False
     Application.ScreenUpdating = True
     
End Sub

 


 

 

 

 

 

Read 2558 times