一个工作簿内有多个工作表,一个文件内有多个工作簿,怎样一键弹出这个文件夹内所有工作簿一共有多少个工作表 求大神的代码!!!万分感谢!!!
æ°å»ºä¸ä¸ªxlsmæ件ï¼å¤å¶å¦ä¸ä»£ç å°è¿ä¸ªæ件ä¸ï¼F5æ§è¡ä»£ç
å°±å¯å¼¹åºå·¥ä½è¡¨æ°éï¼æ³¨æå·¥ä½ç°¿é»è®¤æ¯xlsxæ ¼å¼ï¼
Sub é±¼æ¨æ··çª()
Application.ScreenUpdating = False
f = Dir(ThisWorkbook.Path & "\*.xlsx")
Do While f <> ""
Workbooks.Open ThisWorkbook.Path & "\" & f
æ°é = æ°é + ActiveWorkbook.Sheets.Count
ActiveWorkbook.Close
f = Dir
Loop
Application.ScreenUpdating = True
MsgBox æ°é
End Sub追é®
å°±å¯å¼¹åºå·¥ä½è¡¨æ°éï¼æ³¨æå·¥ä½ç°¿é»è®¤æ¯xlsxæ ¼å¼ï¼
Sub é±¼æ¨æ··çª()
Application.ScreenUpdating = False
f = Dir(ThisWorkbook.Path & "\*.xlsx")
Do While f <> ""
Workbooks.Open ThisWorkbook.Path & "\" & f
æ°é = æ°é + ActiveWorkbook.Sheets.Count
ActiveWorkbook.Close
f = Dir
Loop
Application.ScreenUpdating = True
MsgBox æ°é
End Sub追é®
è¿ä¸ªxlsmæ件æ¯å¨è¿ä¸ªæ件夹å æ°å»ºåï¼å¦ææ¯çè¯æç¨äºï¼ä¸å¯¹å
追çæ¯åï¼æä»ä¹é误æ示åï¼è¿æä½ çå·¥ä½ç°¿æ¯ä¸æ¯é½æ¯xlsxæ ¼å¼çï¼
追é®å¦ææ¯xlsçå·¥ä½ç°¿éè¦æä¹ååï¼
追çæf = Dir(ThisWorkbook.Path & "\*.xlsx")è¿è¡
æ¹æ
f = Dir(ThisWorkbook.Path & "\*.xls")
温馨提示:答案为网友推荐,仅供参考