æå½åå·¥ä½ç°¿ä¸çå 个表å¤å¶å°ä¸ä¸ªæ°å·¥ä½ç°¿ä¸ï¼ç¨VBAä¸è¡ä»£ç å°±å¯ä»¥å®ç°ï¼
Sheets(Array("è¾å
¥è¡¨","è¾åºè¡¨","年级æå表")).Copy
å®ç°æ°å»ºå·¥ä½ç°¿çå¦å为ï¼éè¦ä¸¤ä¸ªè¯å¥ï¼ä¸ä¸ªæ¯éæ©æ件åï¼
fn = Application.GetSaveAsFilename
ä¸ä¸ä¸ªè¯å¥å°±æ¯ä¿åï¼
ActiveWorkbook.SaveAs fn
å½ç¶ï¼è¿ä¸¤ä¸ªè¯å¥å¯è½éè¦æ´ç»åï¼ä¾å¦éæ©æ件夹æ¶åæå®é»è®¤ä½ç½®ãæ件类åï¼ä¿ååæ£æ¥æ件æ¯å¦è¦çãåååç¼æ¯å¦æ£ç¡®çã
温馨提示:答案为网友推荐,仅供参考