Visual Basic for Applications (VBA) i Excel - Avancerat Träningskurs

Last updated

Kurskod

vbaexceladv

Varaktighet

14 timmar (vanligtvis 2 dag inklusive pauser)

Översikt

Kursen avslöjar hemligheterna för effektiv skrivning av avancerade applikationer i VBA applikationen MS Excel .

Efter kursen kan du:

  • Skriv en avancerad objektorienterad applikation
  • Konvertera textfiler
  • Användning av externa datakällor
  • Använd externa bibliotek

Kursplan

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)

Vittnesmål

★★★★★
★★★★★

We also do Consultancy!

We work with leading clients across a wide range of technologies!

Reach out for Project | Staff Enhancement | System Audit Consulting

Relaterade Kategorier

Relaterade Kurser

Rabatterade kurser

No course discounts for now.

Nyhetsbrev & Erbjudanden

Anmäl dig till vårt nyhetsbrev så får du information om aktuella rabatter på öppna kurser. Vi respekterar ditt privatliv, så att din e-postadress kommer endast att användas för sändning vårt nyhetsbrev. När som helst kan du ändra inställningarna eller helt avbeställa den.

Våra kunder

is growing fast!

We are looking to expand our presence in Sweden!

As a Business Development Manager you will:

  • expand business in Sweden
  • 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