æAlt+F11ï¼æå¼VBAç¼è¾å¨ï¼æå
¥ä¸ä¸ªæ¨¡åï¼æä¸é¢ç代ç è´´è¿å»ï¼æF5æ§è¡
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/472309f79052982207e0b196dbca7bcb0b46d490?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
Sub æé®1_Click()
Columns("A:A").Select 'æ¸
空Aå
Selection.ClearContents
Range("A1").Select
myPath = "E:\FILE\" 'ææ件路å¾å®ä¹ç»åéï¼ä½ è¦æ±éçæ件夹
n = 1
myFile = Dir(myPath & "\9*.xl*") '9*.xl*æ¯ä½ çæ件ç¹å¾
Do While myFile <> ""
Cells(n, 1) = myFile 'ååºå
¨é¨ç¬¦åè¦æ±çæ件å
myFile = Dir 'æ¾å¯»ä¸ä¸ä¸ªæ件
n = n + 1
Loop
lastrow = Cells(Rows.Count, 1).End(3).Row 'æ¾Aåæåä¸è¡æ°
For i = 1 To lastrow
Workbooks("æ件æç´¢.xlsm").Sheets("catalog").Select 'æ件æç´¢.xlsmå°±æ¯æ¬æ件åï¼catalogæ¯æ¬å·¥ä½è¡¨å
m = Cells(i, 1)
ChDir "E:\File"
Workbooks.Open Filename:="E:\File\" & m 'æå¼å表ä¸çæ件
Sheets("Sheet1").Select 'éæ©å·¥ä½è¡¨Sheet1
Sheets("Sheet1").Copy After:=Workbooks("æ件æç´¢.xlsm").Sheets(1) 'æ·»å å°æ件æç´¢.xlsmå·¥ä½ç°¿ä¸
Workbooks("æ件æç´¢.xlsm").Activate
Sheets("Sheet1").Activate
Sheets("Sheet1").Name = m 'ä¿®æ¹å·¥ä½è¡¨å为æ件å
Workbooks(m).Activate
ActiveWorkbook.Close True 'å
³éåæå¼çæ件
Next i ' å¤çä¸ä¸ä¸ªæ件
End Sub
æµè¯éè¿ã