Visual Basic for Applications (VBA) in Excel - Advanced Training Course

Description

• Type

  Course

• Methodology

  Online

Description

The course reveals the secrets of effective writing advanced applications in VBA application MsExcel.
After the course you can:
Write an advanced object-oriented application
Convert text files
Use of external data sources
Use external libraries

About this course

Requirements

It is assumed that course participants are already familiar with Excel spreadsheet and know how to program in VBA or any procedural language (Pascal, C, Basic, etc.). It is recommended to complete the course Visual Basic for Applications - Introduction to Programming

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

Send

We will only publish your name and question

Request information

We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.

Thank you!

We are reviewing your question. We will publish it shortly.

Or do you prefer the center to contact you?

Request information

Reviews

Have you taken this course? Share your opinion

Subjects

• Excel
• Object oriented training
• Visual Basic training
• Object-oriented training
• Property
• Writing
• Visual Basic
• Programming
• Oriented Programming
• MS Excel

Course programme

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 classroom

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)

Additional information

21 hours (usually 3 days including breaks)

See related categories

• Object oriented training courses
• Distance learning Object oriented training courses
• Writing courses
• Distance learning Writing courses
• MS Excel courses
• Distance learning MS Excel courses
• Excel vba courses
• Technical writing courses
• Speed writing courses
• Excel 2007 courses
• Advanced excel courses
• Excel introduction courses
• Excel intermediate courses
• Bid writing courses
• Technical report writing courses
• Medical writing courses
• Excel training courses
• Travel writing courses
• Legal writing courses
• Science writing courses
• Scientific writing courses
• Excel courses
• Distance learning Excel courses
• Distance learning Course
• Nobleprog Limited courses