|
楼主 |
发表于 2010-5-4 13:55
|
显示全部楼层
Cells(6, 4).ClearContents
fTy = Cells(4, 2)
Select Case fTy
Case "pdf"
PDFApp.Open MyFile
Cells(6, 4) = "文件总页数"
Cells(j, 4) = PDFApp.GetNumPages
PDFApp.Close
Case "doc" '来自老朽代码的修改,好多了
Set MyDoc = GetObject(Cells(j, 3).Value)
Cells(6, 4) = "文件总页数"
Cells(j, 4) = MyDoc.ActiveWindow.ActivePane.Pages.Count
Set MyDoc = Nothing
Case "*"
nN = InStrRev(MyFile, ".")
Cells(6, 4) = "文件类型"
Cells(j, 4) = Mid(MyFile, nN + 1)
Case Else
End Select
[ 本帖最后由 zzf_ 于 2010-5-4 14:06 编辑 ] |
|