王佩丰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
阅读 902
1 声望
0 粉丝
0 条评论
你知道吗?

1 声望
0 粉丝
文章目录
宣传栏