|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
科技时代,我们成了电脑族,为减轻工作压力和负担,VBA我喜欢!
各位看官、过客、高人、隐士,看看下面这两段代码,您会怎么改?为什么
Sub 数据上报()
Sheets("花名册").Select
Range("A5:BH65530").Select
Selection.Copy
Dim wkbk As Workbook
Dim myFileName As String
myFileName = Application.GetOpenFilename("EXCEL文件(*.xlsm), *.xlsm")
If myFileName = "False" Then
MsgBox "请选择文件!", vbInformation, "取消"
Else
Set wkbk = Workbooks.Open(myFileName)
Sheets("总花名册").Select
Range("A5").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A5").Select
MsgBox "文件上报成功,请保存该文件!"
End If
ActiveWorkbook.Save
End Sub
Sub 数据接收()
Dim wkbk As Workbook
Dim myFileName As String
myFileName = Application.GetOpenFilename("EXCEL文件(*.xlsm), *.xlsm")
If myFileName = "False" Then
MsgBox "请选择文件!", vbInformation, "取消"
Else
Set wkbk = Workbooks.Open(myFileName)
Sheets("总花名册").Select
Range("A5:BH65530").Select
Selection.Copy
Windows("总花名册附表-xls版.xlsm").Activate
Sheets("花名册").Select
Range("A5").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A5").Select
MsgBox "文件导入成功,请保存该文件!"
End If
ActiveWorkbook.Save
End Sub |
|