Wise Owl Training - VBA macros blogs (page 3 of 4)
Showing blogs 41-60 (out of 70)
Posted by Andy Brown on 24 February 2012 | no comments
Excel and other MS Office applications make extensive use of enumerations - and you should too!
Posted by Andy Brown on 20 February 2012 | no comments
In certain cases in VBA (displaying the contents of folders, listing hierarchical data) writing a program which calls itself is by far the easiest way to go - this blog gives worked examples of 3 such recursive programs.
Posted by Andy Brown on 09 February 2012 | 1 comment
To become an efficient programmer, you need to stop writing one long subroutine and start writing lots of small ones instead - and to do this, you're going to need to know everything there is to know about passing arguments.
Posted by Andy Brown on 06 February 2012 | 1 comment
Learn how to write VBA macros to add, edit and delete data in Access, SQL Server and other databases, using something called ADO.
Posted by Andy Brown on 23 January 2012 | 1 comment
By referencing the unintuitively named Microsoft Scripting Runtime object library you can write VBA code to access files and folders on your hard disk. This blog explains how, and gives a couple of worked examples.
Posted by Andy Brown on 13 January 2012 | 2 comments
The easiest way to work with text files in VBA is using TextStream objects - this blog explains how they work.
Posted by Andy Brown on 13 January 2012 | 1 comment
To make it easier for users of your VBA systems to choose files, you can show FileDialogs on screen. This blog explains what these are, and how to customise them.
Posted by Andy Brown on 13 January 2012 | no comments
In order to work efficiently with files and folders you first need to create a FileSystemObject. This blog explains how to do this!
Posted by Andy Brown on 03 January 2012 | no comments
Did you know that you can create and manage references from within VBA code? This article gives you ideas on how to do just that.
Posted by Andy Brown on 09 December 2011 | 1 comment
Although it's usually easiest to create references to other applications using the Tools/References menu as described in an earlier blog, you can use the method shown in this blog instead.
Posted by Andy Brown on 05 December 2011 | 6 comments
Even if you're writing Visual Basic macros within Excel, there's nothing to stop you inserting text into Word documents, manipulating PowerPoint slides or sending Outlook emails. This blog explains how to reference other applications, and write macros in Excel to link to other Microsoft Office software
Posted by Andy Brown on 29 November 2011 | no comments
What happens when your macros go wrong? That depends what error-handling you have in place. Learn how to use ON ERROR and other commands to trap errors in a structured way.
Posted by Andy Brown on 25 November 2011 | 1 comment
This series of blogs is intended to provide online training in how to debug in Visual Basic for Applications, including using breakpoints and the immediate window.
Posted by Andy Brown on 22 November 2011 | 2 comments
Want to do something when a user opens a workbook, or stop them clicking on a particular cell? You need to learn how to attach code to Excel workbook or worksheet events!
Posted by Andy Brown on 15 November 2011 | 5 comments
There are 4 types of loop in Visual Basic for Applications - this blog shows how and when to use each type of VBA loop structure.
Posted by Andy Brown on 15 November 2011 | no comments
This part of the Excel VBA training series of blogs shows how to use IF / ELSE / END IF within VBA, and also how to use the alternative SELECT / CASE syntax within macros.
Posted by Andy Brown on 09 November 2011 | 9 comments
Visual Basic for Applications (VBA) is what's called an object-orientated programming language. This blog explains what this means!
Posted by Andy Brown on 03 October 2011 | 1 comment
The InputBox function in Visual Basic for Applications allows you to get - as the name suggests - input from the user. This blog shows how to use it!
Posted by Andy Brown on 28 September 2011 | 2 comments
The MsgBox command in Visual Basic for Applications allows you to display basic messages, but you can also make it prettier, and even use it to ask questions or display multiple-line messages! Read on to find out more about this versatile VBA command.
Posted by Andy Brown on 05 September 2011 | 6 comments
This blog explains the nuts and bolts of Excel VBA variables, including how to declare them, how to set their scope and all sorts of other tips and tricks. The blog also covers constants in Excel macros.
MS OFFICE BLOGS
VBA MACROS BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR