Lecture Description
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
Download files here www.wiseowl.co.uk/videos/excelvba/splitting-strings.htm
www.wiseowl.co.uk - This video explains how to use VBA functions to split strings into their constituent parts. You'll learn about the Left, Right and Mid functions for extracting parts of a string, how to identify the position of one string within another using the InStr and InstrRev functions and how to use the Split function to break a single string into multiple parts and store them in an array.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more
Course Index
- Getting Started in the VB Editor
- Writing Your First VBA Macro
- What to do When Things Go Wrong (Errors and Debugging)
- Buttons, Toolbars and Keyboard Shortcuts
- Selecting Cells (Range, Cells, Activecell, End, Offset)
- Worksheets, Charts and Sheets
- Workbooks
- Variables
- Object Variables
- Message Boxes
- Input Boxes
- Application.InputBox
- With Statements
- If Statements
- Select Case Statements
- Do Until and Do While Loops
- Find and FindNext
- For Next Loops
- For Each Loops
- Creating Functions
- Error Handling (On Error, Resume, GoTo)
- Event Procedures
- Application Events
- User Forms
- Files and Folders (FileSystemObjects)
- Text Files (FileSystemObjects)
- File Dialogs
- Arrays
- Constants and Enumerations (Const, Enum)
- Creating Word Documents
- Creating and Updating Linked Word Tables
- Creating PowerPoint Presentations
- Creating Outlook Emails
- ADO (ActiveX Data Objects) Querying a Database
- ADO (ActiveX Data Objects) Modifying Data with Recordsets
- ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)
- Creating Add Ins
- Type Declarations (UserDefined Types)
- Class Modules
- Using Class Modules in Other Projects
- Custom Collections
- Typed Collections
- Dictionaries
- Disabling Screen Updates
- Saving as a PDF
- Data Labels in Scatter Charts
- ByRef and ByVal
- ByRef and ByVal (When to use Parentheses)
- Making Excel Talk
- Finding the Last Used Row, Column and Cell
- Querying Web Pages using Query Tables
- Browsing to Websites and Scraping a Web Page
- Web Scraping Across Multiple Pages
- Downloading Files from Websites
- Introduction to Charts in VBA
- Embedding Charts in Worksheets
- Introduction to Pivot Tables in VBA
- Pivot Tables using an Access Database
- Pivot Tables using a SQL Server Database
- Pivot Tables and Consolidation Ranges
- PowerPivot Data Models
- Pivot Charts
- Pivot Table Slicers
- Pivot Table Date Fields and Timelines
- Introduction to Shapes
- Formatting Shapes
- Adding Text to Shapes
- Working with Strings
- Splitting Strings
- The Join Function and Concatenating Strings
- Replacing Strings
- Converting the Case of Text
- The Asc and Chr Functions
- The IIf Function
- The Switch Function
- Working with Dates
Course Description
Excel VBA is a powerful (and fun!) tool which allows you to automate your Excel workbooks. These videos will help you through your first steps on the way to becoming a programmer in Excel. You don't need any prior programming knowledge as we'll take things from first principles and hopefully give you a flavour of the cool things you can do with a little bit of effort!