Sub test()
Dim wk As Workbook
s$ =
Set wk = Workbooks.Open(ThisWorkbook.Path & "\表2.xls") '此处用open吧
wk.Sheets.Add , wk.Worksheets(wk.Worksheets.Count)
wk.Worksheets(wk.Worksheets.Count).Name = s
wk.Save
wk.Close '这里仅仅是关闭而已。用不用都随你
Set wk = Nothing
End Sub
Sub test()
Dim wk As Workbook
s$ = [b4]
Set wk = Workbooks.Open(ThisWorkbook.Path & "\表2.xls") '此处用open吧
wk.Sheets.Add , wk.Worksheets(wk.Worksheets.Count)
wk.Worksheets(wk.Worksheets.Count).Name = s
wk.Save
wk.Close '这里仅仅是关闭而已。用不用都随你
Set wk = Nothing
End Sub
Sub 遍历引用数据() 'laosanjie 2008-9-5
Dim x As Byte, 路径$, 簿名$, AK As Workbook
Application.ScreenUpdating = False
x = 1
路径 = ThisWorkbook.Path & "\数据表\"
簿名 = Dir(路径 & "*.xls") '依次找寻指定路径中的*.xls文件
Do While 簿名 <> "" '当指定路径中有文件时进行循环
If 簿名 <> ThisWorkbook.Name Then
Set AK = Workbooks.Open(路径 & 簿名) '打开符合要求的文件
If AK.Sheets(1).Range("A1") <> 0 Then
With AK.Sheets(1)
Range("A" & x) = .Range("A1")
End With
Workbooks(簿名).Close False '关闭源工作簿,并不作修改
x = x + 1
End If
End If
簿名 = Dir '找寻下一个*.xls文件
Loop
Application.ScreenUpdating = True
End Sub
这个你可以根据自己的要求修改下
Sub test()
Dim wk As Workbook
s$ = [b4]
Set wk = GetObject(ThisWorkbook.Path & "\表2.xls")
wk.Sheets.Add , wk.Worksheets(wk.Worksheets.Count)
wk.Worksheets(wk.Worksheets.Count).Name = s
wk.Save
wk.Close
Set wk = Nothing
End Sub