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 的保護表
- 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)
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.
