Sumários
VBA – II & III
6 Dezembro 2021, 18:00 • FILIPE CALDEIRA SANTOS
Objects and Collections
Workbooks, Cells and Ranges
Programming Formulas and Functions
Arrays
Logical Operators and Blocks
VBA – I
29 Novembro 2021, 18:00 • FILIPE CALDEIRA SANTOS
Introduction
Macros and Modules
Visual Basic Editor
Variables and Constants
Data Types
Variable Declaration
Variable Scope
VBA – II & III
24 Novembro 2021, 18:00 • FILIPE CALDEIRA SANTOS
Objects and Collections
Workbooks, Cells and Ranges
Programming Formulas and Functions
Arrays
Logical Operators and Blocks
Loops
Automating MsExcel
Interacting with MsWord and MsOutlook
Debugging
Built-In Functions and Analysis Tools - II
22 Novembro 2021, 18:00 • FILIPE CALDEIRA SANTOS
Date and Time Functions
Text Functions
Basic Database features
Importing Data
VBA – I
17 Novembro 2021, 18:00 • FILIPE CALDEIRA SANTOS
Introduction
Macros and Modules
Visual Basic Editor
Variables and Constants
Data Types
Variable Declaration
Variable Scope