éè¿ç¨åºæå¼å°±å¥½ï¼å 为好å¤è¡¨æå¨æå¼å¾éº»ç¦ãç°å¨ææä¸ä¸ªé®é¢æ¯ï¼æå¼åè½å¤è¯»å°è¡¨å çæ°ï¼ä½æ¯ä¸è½ç»å½åçè¡¨æ ¼å¡«å读å°çæ°ï¼è¯·é®è¯¥æä¹åï¼Cells(3, 2) = Workbooks(s_name1).Sheets(s_name).[b3]ï¼cell(3,2)è¿ä¸ªåå æ ¼æ²¡æå¡«ä¸æ°
追çæå¼åå ¶å®å½å表已ç»æ¯Workbooks(s_name1)äºï¼ä½ åºè¯¥å¨Cells(3, 2)åå ä¸ä¸»è¡¨çå ¨ç§°ï¼å¦ï¼Workbooks("主表").Sheets("主表").Cells(3, 2)