word宏(html转word)

Sub 宏1()
    Dim MyFile As String
    Dim Arr(1000) As String     '一次处理最大的文件数量,根据需要修改数字1000改为需要处理的数量
    Dim count As Integer
    MyFile = Dir("C:\Users\Administrator\Desktop\pc\OPS\" & "*.html")   
    count = count + 1
    Arr(count) = MyFile
    Do While MyFile <> ""
        MyFile = Dir
        If MyFile = "" Then
            Exit Do
        End If
        count = count + 1
        Arr(count) = MyFile         '将文件的名字存在数组中
    Loop
    For i = 1 To count
        Documents.Open FileName:="C:\Users\Administrator\Desktop\pc\OPS\" & Arr(i), ConfirmConversions:=False, ReadOnly:= _  
        False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:= _
        "", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="", _
        Format:=wdOpenFormatAuto, XMLTransform:=""
        ActiveDocument.SaveAs FileName:="C:\Users\Administrator\Desktop\pc\" & Replace(Arr(i), ".html", ".doc"), FileFormat:=wdFormatDocument, _
        LockComments:=False, Password:="", AddToRecentFiles:=True, WritePassword _
        :="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
        SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _
        False
        ActiveDocument.Close
    Next
End Sub


第一个第二个都是html的地址
第三个是目标储存地址

 缺点:顺序不对

posted @ 2016-07-10 11:42  V5八旗  阅读(261)  评论(0)    收藏  举报