Visual Basic for Applications (VBA) in Excel - Advanced培训

课程编码

vbaexceladv

课程时长

14 小时 通常来说是2天,包括中间休息。

要求

  • An understanding of VBA
  • Procedural programming experience

Audience

  • Data Analysts

课程概览

该课程揭示了在VBA应用程序Ms Excel中有效编写高级应用程序的秘诀。

课程结束后,您可以:

  • 编写高级面向对象的应用程序
  • 转换文本文件
  • 使用外部数据源
  • 使用外部库

Machine Translated

课程大纲

Excel Object Model

  • The protection sheet from VBA
  • Object Workbook, Workbooks collection
  • Worksheet Object, Collection Worksheets
  • Validation sheets
  • Practical methods of the Range object
  • Copy, paste, paste special
  • Property CurrentRegion
  • Find, replace
  • Sorting ranges
  • Charts (Object Chart)

Events

  • Application-level events

Boards

  • Dynamic arrays
  • Table arrays Variant
  • Optimizing arrays and memory
  • Multi-dimensional arrays

Object-Oriented Programming

  • Classes and Objects
  • Creating classes
  • Creating and Destroying Objects
  • Create methods
  • Create property
  • Validation data using property
  • The default properties and methods
  • Error handling in the class module

Create and manage collections

  • Create a collection
  • Adding and removing items
  • References to the components (using a key and an index)

Advanced structures and functions VBA

  • Passing parameters by value and reference (ByRef and ByVal)
  • Procedures with a variable number of parameters
  • Optional Parameters and Defaults
  • Procedures of unknown number of parameters (ParamArray)
  • Enumeration, convenient parameter passing
  • Type the user (User-defined Type)
  • Service Null, Nothing, empty string "", Empty, 0
  • Type conversion (Conversion)

File Operations

  • Opening and closing text files
  • Reading and writing text and binary data
  • Processing of records in the CSV file
  • Efficient processing of text files

Use VBA functions in other applications

Extras

  • Create your own add-ons
  • Create a toolbar for addition
  • Installing your own add-ons and their protection

Using external libraries

Connecting to external databases (ODBC, OLEDB)

客户评论

★★★★★
★★★★★

课程分类

相关课程

促销课程

订阅促销课程

为尊重您的隐私,我公司不会把您的邮箱地址提供给任何人。您可以享有优先权和随时取消订阅的权利。

我们的客户

is growing fast!

We are looking to expand our presence in China!

As a Business Development Manager you will:

  • expand business in China
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions