5,139
社区成员
发帖
与我相关
我的任务
分享
Dim myApp As New Application, wkSht As Worksheet
Dim wk1 As Workbook, wk2 As Workbook
Dim sFileName
Set wk1 = ActiveWorkbook
sFileName = Application.GetOpenFilename
If sFileName = "False" Then
GoTo endSub
End If
Workbooks.Open sFileName
Set wk2 = ActiveWorkbook
Set wkSht = wk2.Sheets(1)
wkSht.Range("A4:B" & Cycle).Copy
wk1.Activate
Worksheets("第一个文件").Range("F20").PasteSpecial Paste:=xlPasteValues
wk2.Close
Set wkSht = myApp.Workbooks.Open(sFileName).Sheets(1)
wkSht.Range("A4:B" & cycle).Copy
Set wkSht = myApp.Workbooks.Open(sFileName).Sheets(1)
wkSht.Range("A4:B" & cycle).Copy
Worksheets("第一个文件").Range("A2").Select
ActiveSheet.PasteSpecial Format:="文本"