课程大纲
Excel 物件模型
- 来自 VBA 的保护表
- Workbook 物件,Workbooks 集合
- Worksheet 物件,Worksheets 集合
- 验证表
- Range 物件的实用方法
- 复制、贴上、特殊贴上
- CurrentRegion 属性
- 寻找、替换
- 范围排序
- 图表 (Chart 物件)
事件
- 应用程式层级事件
阵列
- 动态阵列
- Variant 表阵列
- 优化阵列和记忆体
- 多维阵列
物件导向 Programming
- 类别和物件
- 建立类别
- 建立和销毁物件
- 建立方法
- 建立属性
- 使用属性验证资料
- 预设属性和方法
- 类别模组中的错误处理
建立和管理集合
- 建立集合
- 添加和移除项目
- 引用元件 (使用键和索引)
进阶结构和函数 VBA
- 按值和按引用传递参数 (ByRef 和 ByVal)
- 具有可变数量参数的程序
- 可选参数和预设值
- 未知数量参数的程序 (ParamArray)
- 枚举,方便参数传递
- 使用者定义类型 (User-defined Type)
- 服务 Null, Nothing, 空字串 "", Empty, 0
- 类型转换 (Conversion)
档案操作
- 打开和关闭文字档案
- 读写文字和二进位资料
- 处理 CSV 档案中的记录
- 高效处理文字档案
在其他应用程式中使用 VBA 函数
附加功能
- 建立自己的附加元件
- 建立附加元件的工具列
- 安装自己的附加元件及其保护
使用外部函式库
连接到外部资料库 (ODBC, OLEDB)
客户评论 (7)
I like the hands on training and seeing us solve for issues on the spot.
Jon Matrille - LocumTenens.com
课程 - Visual Basic for Applications (VBA) in Excel - Advanced
I really enjoy the training. Huge and practical! knowledge of the trainer combined with his skill to conduct the training made the training time very efficient. The trainer recognized the level of participant's experience in VBA and provided exercises relevant to that experience which made the training very useful.
Barbara Peek - UBS Business Solutions Poland Sp. z o.o.
课程 - Visual Basic for Applications (VBA) in Excel - Advanced
I was benefit from the trainer knowledge, explanation and tips.
Kornel Tymcio - UBS Business Solutions Poland Sp. z o.o.
课程 - Visual Basic for Applications (VBA) in Excel - Advanced
I liked the trainer, nice guy with great attitude.
Lukasz Kanior - UBS Business Solutions Poland Sp. z o.o.
课程 - Visual Basic for Applications (VBA) in Excel - Advanced
I generally enjoyed the knowledge and sense of humor.
Lukasz Rozga - UBS Business Solutions Poland Sp. z o.o.
课程 - Visual Basic for Applications (VBA) in Excel - Advanced
I mostly was benefit from the fitted training to people needs.
Robert Solek - UBS Business Solutions Poland Sp. z o.o.
课程 - Visual Basic for Applications (VBA) in Excel - Advanced
The whole topic is interesting - everything was OK.