王佩丰Excel学习-04VBA操作工作簿
文章目录
变量定义
Dim i as Interger
Dim rng as Range
Dim biao as WorkSheet
Workbooks.Open Filename = 'd:\data\1.xlsx'
ActiveWorkbook.Close
ActiveWorkbook.Add
ActiveWorkbook.Save
ActiveWorkbook.SaveAs
.
For Each
For Each A in Range("a1:a10")
For Each A in Worksheets

评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论