王佩丰Excel学习04VBA操作工作簿

48次阅读

共计 219 个字符，预计需要花费 1 分钟才能阅读完成。 

 变量定义 

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

正文完
excel vba
发表至：无分类
2019-11-16
 0