Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
課程簡介
Excel 物件模型
- VBA的保護片
- 物件工作簿、工作簿集合
- Worksheet 物件、集合工作表
- 驗證表
- Range 對象的實用方法
- 複製、粘貼、粘貼特殊
- 屬性 CurrentRegion
- 查找、替換
- 排序範圍
- 圖表（物件圖表）
事件
- 應用程式級事件
板
- 動態陣列
- 表陣組 Variant
- 優化陣列和記憶體
- 多維陣列
面向物件Programming
- 類和物件
- 創建類
- 創建和銷毀物件
- 創建方法
- 創建屬性
- 使用屬性驗證數據
- 默認屬性和方法
- 類模組中的錯誤處理
創建和管理集合
- 創建集合
- 添加和刪除專案
- 對元件的引用（使用鍵和索引）
進階結構和功能VBA
- 依值和引用傳遞參數（ByRef 和 ByVal）
- 具有可變數數的過程
- 可選參數和預設值
- 未知參數數的過程 （ParamArray）
- 枚舉，方便參數傳遞
- 鍵入使用者（使用者定義類型）
- 服務 Null， Nothing， 空字串 “”， Empty， 0
- 類型轉換 （Conversion）
檔操作
- 打開和關閉文字檔
- 讀取和寫入文字和二進位數據
- 處理 CSV 檔中的記錄
- 高效處理文字檔
在其他應用程式中使用 VBA 函數
額外
- 創建您自己的附加元件
- 創建添加的工具列
- 安裝您自己的附加元件及其保護
使用外部庫
連接到外部資料庫（ODBC、OLEDB）
14 時間：
客戶評論 (7)
I like the hands on training and seeing us solve for issues on the spot.
Jon Matrille - LocumTenens.com
Course - 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.
Course - 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.
Course - 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.
Course - 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.
Course - 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.
Course - Visual Basic for Applications (VBA) in Excel - Advanced
The whole topic is interesting - everything was OK.
