è¿ä¸ªéè¦ç¨vba解å³ï¼
ï¼1ï¼æ°å»ºä¸ä¸ª excelæ件
ï¼2ï¼ç¶å act+f11 å¼¹åºvbaçé¢
ï¼3ï¼æä¸ä¸ä»£ç å¤å¶å°vbaéé¢
Sub wenä¸é®å并()
'å®ä¹å¯¹è¯æ¡åé
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
'æ°å»ºä¸ä¸ªå·¥ä½ç°¿
Dim newwb As Workbook
Set newwb = Workbooks.Add
With fd
If .Show = -1 Then
'å®ä¹å个æ件åé
Dim vrtSelectedItem As Variant
'å®ä¹å¾ªç¯åé
Dim i As Integer
i = 1
'å¼å§æ件æ£ç´¢
For Each vrtSelectedItem In .SelectedItems
'æå¼è¢«å并工ä½ç°¿
Dim tempwb As Workbook
Set tempwb = Workbooks.Open(vrtSelectedItem)
'å¤å¶å·¥ä½è¡¨
tempwb.Worksheets(1).Copy Before:=newwb.Worksheets(i)
'ææ°å·¥ä½ç°¿çå·¥ä½è¡¨ååæ¹æ被å¤å¶å·¥ä½ç°¿æ件åï¼è¿å¿åºç¨äºxlsæ件ï¼å³Excel97-2003çæ件ï¼å¦ææ¯Excel2007ï¼éè¦æ¹æxlsx
newwb.Worksheets(i).Name = VBA.Replace(tempwb.Name, ".xls", "") 'å
³é被å并工ä½ç°¿
tempwb.Close SaveChanges:=False
i = i + 1
Next vrtSelectedItem
End If
End With
Set fd = Nothing
End Sub
ï¼4ï¼è¿è¡
追é®actæ¯åªä¸ªé®ï¼