Excel VBA

Excel VBA Creating Outlook Emails

December 8, 2015 0

Excel VBA Introduction Part 29 – Creating Outlook Emails DESCRIPTION Writing VBA code in Excel doesn’t only allow you to control Excel, you also have access to all of the other Office applications. This video […]

Excel VBA

Excel VBA Creating PowerPoint Presentations

December 1, 2015 0

Excel VBA Introduction Part 28 – Creating PowerPoint Presentations DESCRIPTION Writing VBA code in Excel doesn’t only allow you to control Excel, you also have access to all of the other Office applications. This video […]

Excel VBA

Excel VBA Creating Word Documents

November 24, 2015 0

Excel VBA Introduction Part 27 – Creating Word Documents DESCRIPTION Writing VBA code in Excel doesn’t only allow you to control Excel, you also have access to all of the other Office applications. This video […]

Excel VBA

Excel VBA Constants and Enumerations

November 17, 2015 0

Excel VBA Introduction Part 26 – Constants and Enumerations DESCRIPTION Constants in VBA are values which don’t change – there are lots of built-in examples and you can also create your own. This video teaches […]

Excel VBA

Excel VBA Arrays

November 10, 2015 0

Excel VBA Introduction Part 25 – Arrays DESCRIPTION An array is a lot like a variable, only with an array you can store more than one value under the same variable name. This video explains […]

Excel VBA

Excel VBA File Dialogs

November 3, 2015 0

Excel VBA Introduction Part 24 – File Dialogs DESCRIPTION Using FileDialogs in VBA provides a convenient method for selecting files and folders and performing useful actions on them. This video covers how to use the […]

Excel VBA

Excel VBA Text Files

October 27, 2015 0

Excel VBA Introduction Part 23 – Text Files DESCRIPTION The Scripting Runtime Object Library allows you to write VBA code to create, open, read from and write to text files using very simple methods. This […]

Excel VBA

Excel VBA Files and Folders

October 20, 2015 0

Excel VBA Introduction Part 22 – Files and Folders DESCRIPTION The Scripting Runtime Object Library allows you to easily write code in an Excel VBA project which can manipulate the file and folder structure of […]

Excel VBA

Excel VBA User Forms

October 13, 2015 0

Excel VBA Introduction Part 21 – User Forms DESCRIPTION Designing a User Form in VBA is a great way to allow you users to interact with your workbook. This video teaches you how to create […]

Excel VBA

Excel VBA Event Procedures

October 6, 2015 0

Excel VBA Introduction Part 20 – Event Procedures DESCRIPTION Writing Event Procedures allows you to create subroutines which run automatically in response to events in a workbook. This video teaches you how to access the […]