1、Excel文件打开和关闭:
'Excel文件打开
Dim Workbook As Workbook
Set Workbook = Workbooks.Open("E:\VBA-Tool.xlsx", UpdateLinks:=0)
'Excel文件关闭
Workbook.Close SaveChanges:=False
2、Application相关设置:
'内容刷新
Application.ScreenUpdating = False
'提示框是否显示
Application.DisplayAlerts = False
3、单元格或区域操作:
'区域内容清空
Range("B4:P5000").ClearContents
'单元格内容设置
Range("B2").Value = "xxx"
'单元格边框等设置
Range("B2").Borders.LineStyle = xlNone
'单元格书式设置(Formula、FormulaR1C1)
Range("B2").Formula = "=4+5"