如何使用VBScript将网站数据保存到文件中?

在以下代码中,如何将文本保存到文本文件(例如,text.txt)而不是当前的MsgBox

myURL = "http://URL.com"

Set oXMLHttp = CreateObject("MSXML2.XMLHTTP")
Set ohtmlFile = CreateObject("htmlfile")

oXMLHttp.Open "GET",myURL,False
oXMLHttp.send

If oXMLHttp.Status = 200 Then

ohtmlFile.Write oXMLHttp.responseText
ohtmlFile.Close

Set oTable = ohtmlFile.getElementsByTagName("table")
For Each oTab In oTable
    MsgBox oTab.Innertext
Next
End If

WScript.Quit

请帮帮我!

谢谢!

alan0633 回答:如何使用VBScript将网站数据保存到文件中?

您可以使用FileSystemObject的OpenTextFile method

您可以在代码顶部与其他对象一起创建FileSystemObject:

Set objFSO = CreateObject("Scripting.FileSystemObject")

并添加以下常量:

Const ForReading = 1,ForWriting = 2,ForAppending = 8

如果要将所有内容附加到同一文件中,则可以在循环外创建并打开文件:

sFileName = "c:\text.txt"
Set objFile = objFSO.OpenTextFile(sFileName,ForAppending,True)
For Each oTab In oTable
    objFile.WriteLine oTab.Innertext
Next
objFile.Close

否则,您可以在循环中创建多个文件:

Dim iTableCounter
iTableCounter = 0

For Each oTab In oTable

    iTableCounter = iTableCounter + 1
    sFileName = "c:\table_" & iTableCounter & ".txt" ' create a dynamic file name using table name perhaps

    Set objFile = objFSO.OpenTextFile(sFileName,ForWriting,True)
    objFile.Write oTab.Innertext
    objFile.Close

Next
本文链接:https://www.f2er.com/3115764.html

大家都在问