试试:
Sub 导入工作表名()
Application.ScreenUpdating = False '关闭屏幕刷新
Dim ss As Workbook
wj = ActiveWorkbook.Name '当前工作簿名称
With Application.FileDialog(msoFileDialogOpen) '打开对话框对象
.AllowMultiSelect = True '多选文件
If .Show = -1 Then '打开操作
MsgBox "被选定导入的文件共 " & .SelectedItems.Count & " 个 !", , "导入数据"
For i = 1 To .SelectedItems.Count '从选定的第1个文件循环到选定的最后一个文件
Set ss = Workbooks.Open(.SelectedItems(i), , ReadOnly) '打开文件并赋值给变量ss
MC = ss.Name '打开的文件名称
GS = Workbooks(MC).Worksheets.Count '打开工作簿中的工作表个数
For j = 1 To GS
hs = Workbooks(wj).ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row + 1
Workbooks(wj).ActiveSheet.Cells(hs, 1) = Workbooks(MC).Sheets(j).Name
Next j
Workbooks(MC).Close SaveChanges:=False '关闭打开的工作簿文件
Next i
Else
MsgBox "没有指定打开的文件!", , "导入工作表名"
Exit Sub
End If
End With
Application.ScreenUpdating = True '屏幕刷新
End Sub
03版本测试通过!
温馨提示:答案为网友推荐,仅供参考