如下:
功能:获取当前工作簿的所有sheet表的打印页码数量
Sub 页码() Dim a I = 1 Sheets.Add After:=Sheets(Sheets.Count) ActiveSheet.Name = "页码" For Each sht In Sheets sht.Activate a = ExecuteExcel4Macro("Get.Document(50)") Sheets("页码").Cells(I, 1) = a I = I + 1 NextEnd Sub