7,763
社区成员
发帖
与我相关
我的任务
分享
LG.Activate
LG.Cells(7, 1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
BOMSheet.Range(BOMSheet.Cells(1, 5) & ":" & BOMSheet.Cells(1, 6)).Copy
MBSheet.Range("A7").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
MBSheet.Range("A7").PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
文件 = "C:\Documents and Settings\All Users\" & 编号 & "-" & WO & ".xlsx"
MBSheet.SaveAs FileName:=文件
也不需要像Excel里一样非要激活这个工作表。已经定义好就可以了MBSheet.Range("A7").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
MBSheet.Range("A7").PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
刚刚解决了,跟Excel中不一样的是这里要用Range选择