能写成这样,还有什么完不成?
部分代码:
Dim xlsheet As Excel.Worksheet
Dim xlbook As Excel.Workbook
ll = ListBox1.ListIndex
Set xlbook = ThisWorkbook.Application.Workbooks.Add(ListBox1.List(ll))
Set xlsheet = xlbook.Worksheets(1)
T11.Text = xlsheet.Range(T1.Text)
xlbook.Close SaveChanges:=False
xlsheet.Copy ThisWorkbook.Sheets(1)
xlbook.Close SaveChanges:=False
若不明白之处,可联系[email protected]