å·¥ä½ä¸ç»å¸¸ä¼ç¨å°excelï¼çç»çè¿è¥excelå¯ä»¥é«æçåå°å·¥ä½éï¼å¾å¤äººå¶ä½excelæ¶ä¼å°ä¸åçæ°æ®åç±»ï¼å°±å½¢æäºä¸ä¸ªexcelä¸æå¤ä¸ªå·¥ä½è¡¨(sheet)ï¼ä½æ¯ç±äºæäºåå éè¦å°è¿äºå·¥ä½è¡¨åç¬æ¾å°ä¸ä¸ªexcelä¸ï¼ä½ç±äºæ°æ®é大ä¼ç»æ们çå·¥ä½å¸¦æ¥å¾å¤å°æ°ï¼æä¹å°excelå¤ä¸ªå·¥ä½è¡¨æåæå¤ä¸ªåç¬çexcelï¼excelæ¯ä¸ªå¾å¼ºå¤§ç软件ï¼æ们æ¥çä¸ä¸æåä¸ä¸ªExcelå·¥ä½ç°¿ä¸çå¤ä¸ªå·¥ä½è¡¨çæ¹æ³
å¼å¯åæ¥é
读模å¼
å·¥å
·ææï¼
excel
æä½æ¹æ³
01
ä¾å¦å·¥ä½èä¸æå¤ä¸ªå·¥ä½è¡¨ï¼å¦å¾ï¼
02
å°ä¸ä¸ªExcelå·¥ä½ç°¿ä¸çå¤ä¸ªå·¥ä½è¡¨(sheet)æåæå¦ä¸å¾æ示ç»æ
03
æå¼éè¦æåçexcelï¼å¨ä»»æå·¥ä½è¡¨å³å»ï¼ç¹å»âæ¥ç代ç â
04
å¨æå¼ççªå£ä¸è¾å
¥å¦ä¸ä»£ç ï¼
Private Sub åæå·¥ä½è¡¨()
Dim sht As Worksheet
Dim MyBook As Workbook
Set MyBook = ActiveWorkbook
For Each sht In MyBook.Sheets
sht.Copy
ActiveWorkbook.SaveAs Filename:=MyBook.Path & "\" & sht.Name, FileFormat:=xlOpenXMLWorkbook 'å°å·¥ä½ç°¿å¦å为xlsxæ ¼å¼
ActiveWorkbook.Close
Next
MsgBox "æ件已ç»è¢«åæå®æ¯!"
End Sub
05
ç¹å»ç»¿è²ä¸è§ï¼è¿è¡ç¨åºï¼çå¾
æåã
06
æåæååï¼ä¼å¼¹åºçªå£æ示ã
07
è¿åExcelå·¥ä½ç°¿æ件æå¨è·¯å¾ å³å¯æ¥çå·²ç»æåçå·¥ä½èã
ç¹å«æ示
æååçå·¥ä½èæ ¼å¼ä¸º.xlsx
çµèä¸æå®è£
excel2007ææå
¼å®¹å
温馨提示:答案为网友推荐,仅供参考