快速确定若干excel文档的页数?

发布网友发布时间：2022-08-09 13:45

共3个回答

热心网友时间：2024-03-15 20:23

亲，这个必须用VBA。代码如下。

要建立两个模块。

Sub GETDIR()
Dim pathA$
With Application.FileDialog(msoFileDialogFolderPicker)
If .Show = False Then Exit Sub
pathA = .SelectedItems(1) & "\"
End With
Range("B1") = pathA
End Sub

Sub zongyeshu()
Dim f, ff As Object
Set fso = CreateObject("Scripting.FileSystemObject")
Set ff = fso.getfolder(Range("B1"))
Dim m, n As Integer
For Each f In ff.Files
    If f.Name <> ThisWorkbook.Name And Left(f.Name, 2) <> "~$" Then
    Workbooks.Open Filename:=Range("B1") & f.Name
    With ActiveWorkbook.ActiveSheet
        .ResetAllPageBreaks
        m = m + 1
        n = n + (ActiveSheet.HPageBreaks.Count + 1) * (ActiveSheet.VPageBreaks.Count + 1)
    End With
    ActiveWorkbook.Close False
    End If
Next f
Set fso = Nothing
Range("B2") = "共有 " & m & " 个文件，一共需打印 " & n & " 页"
End Sub

追问高手！
能否直接形成目录的形式啊？tree那种形式，各项带页数的？

追答

亲，下次尽量把要求一次提完整……

第二段代码需要修订（ys模块），下面是修订后的代码。

Sub zongyeshu()
Dim f, ff As Object
Dim Arr()
Set fso = CreateObject("Scripting.FileSystemObject")
Set ff = fso.getfolder(Range("B1"))
ReDim Arr(0 To ff.Files.Count, 1 To 2)
Dim m, n, p As Integer
For Each f In ff.Files
    If f.Name <> ThisWorkbook.Name And Left(f.Name, 2) <> "~$" Then
    Workbooks.Open Filename:=Range("B1") & f.Name
    With ActiveWorkbook.ActiveSheet
        .ResetAllPageBreaks
        m = m + 1
        p = (ActiveSheet.HPageBreaks.Count + 1) * (ActiveSheet.VPageBreaks.Count + 1)
        Arr(m, 1) = f.Name
        Arr(m, 2) = p
        n = n + p
    End With
    ActiveWorkbook.Close False
    End If
Next f
Set fso = Nothing
Arr(0, 1) = "共有 " & m & " 个文件"
Arr(0, 2) = "共需打印 " & n & " 页"
Range("B2").Resize(UBound(Arr, 1) + 1, 2) = Arr
End Sub

热心网友时间：2024-03-15 20:23

打开每个execl看打印预览，会显示页数

热心网友时间：2024-03-15 20:24

MS木有办法