当文件路径位于变量中时，如何获取表的总行数？

Question

我需要计算Word文档中表1的总行数。 文档路径位于变量中，因为它会根据用户输入而更改。包含路径的变量是fpath。

当我使用变量而不是文件路径时，如何获取表 1 的总行数？

由于 Documents(fpath).Tables(1).Rows.Count，我的代码似乎失败了。

Sub CountTableRows()
    Dim fpath as String  'contains file path                                                             
    Dim fdoc as Document
    Dim trows as Integer 'contains total number of rows in table
    Set fpath = "c:\folder\document.docx"
    Set fDoc = Documents.Open(fpath)
    fDoc.Activate
    trows = Documents(fpath).Tables(1).Rows.Count
    MsgBox "total rows= " & trows
End Sub

Answer 1

您可能希望修改您的代码以使其更具防御性，以便在遇到您隐藏的假设之一时它不会崩溃。 （即文件存在，并且至少有 1 个表）。

Public Function CountTableRows(ByVal ipPath As String, ByVal ipTableNo As Long) As Long

    CountTableRows = -1
    
    Dim myDoc As Word.Document
    If Not TryOpenDoc(ipPath, myDoc) Then
    
        Debug.Print "There was a problem opening '" & ipPath & "'"
        Exit Function
        
        
    End If
    
    Dim myRowCount As Long
    If Not TryCountRows(myDoc, ipTableNo, myRowCount) Then
    
        Debug.Print "Document '" & ipPath & "' does not have Table " & ipTableNo
        Exit Function
        
        
    End If
    
    myDoc.Close
    CountTableRows = myRowCount
    ' MsgBox "Total rows =" & myRowCount
        
End Function


Public Function TryOpenDoc(ByVal ipPath As String, ByRef opDoc As Word.Document) As Boolean

    TryOpenDoc = False
    
    On Error Resume Next
    Set opDoc = Application.Documents.Open(ipPath)
    If Err.Number <> 0 Then Exit Function
    
    Err.Clear
    TryOpenDoc = True
    
End Function


Public Function TryCountRows(ByRef ipDoc As Word.Document, ByVal ipTableNo As Long, ByRef opRowCount As Long) As Boolean

    TryCountRows = False
    If ipDoc.Tables.Count < ipTableNo Then Exit Function
   
    opRowCount = ipDoc.Tables(ipTableNo).Rows.Count
    
    TryCountRows = True
    
End Function