In addition to popular programs like Word, Excel and Access in Microsoft Office, including the latest version, Office 2003, Visual Basic for Applications - VBA - is used for hundreds of other software applications. Learn how to leverage your understanding of your desktop software by creating custom tools to expand the accuracy and productivity of your work.
This article provides a concrete example showing how to use VBA in two Office applications at the same time: Word and Excel 2007. This is a "from the ground up" article intended to help people who are relatively new to VBA macro coding. This article updates a Word document using a Form in Word and an Excel spreadsheet.
If you want to start learning how to write a macro program using Microsoft Office, this is your place to start. This is a "from the ground up" introduction to using Word 2007 VBA and it will get you started even if you have little or not programming experience.
VBA - Visual Basic for Applications - is the only remaining VB6 "COM" level technology in the Microsoft universe. So, for those of us who have our minds deeply into VB.NET, the journey back to VB6 can be a confusing trip. Using a Timer in VB6 is like that. At the same time, how to add timed processes to your code is often not obvious to new users of VBA Macros. This article explains Timers in VBA…
A quick answer to an About Visual Basic reader showing how to code a Word VBA program to score a test using the results of FORMDROPDOWN field codes embedded in the document.
A short, quick article that demonstrates how to access cell values and calculate in a Word document table using Word VBA.
Written for total non-programmers, Learn VBA Macro Coding with Word 2007 starts out by showing you how to write a very simple VBA program that runs in Word in the first lesson. The course does assume that you know how to use a computer and Word 2007, but it does not assume that you know anything about writing a computer program. If you want to know how to get more out of Word, this course is for you.
Written for total non-programmers, Learn VBA Macro Coding with Word 2007 starts out by showing you how to write a very simple VBA program that runs in Word in the first lesson. The course does assume that you know how to use a computer and Word 2007, but it does not assume that you know anything about writing a computer program. If you want to know how to get more out of Word, this course is for you.
Written for total non-programmers, Learn VBA Macro Coding with Word 2007 starts out by showing you how to write a very simple VBA program that runs in Word in the first lesson. The course does assume that you know how to use a computer and Word 2007, but it does not assume that you know anything about writing a computer program. If you want to know how to get more out of Word, this course is for you.
Written for total non-programmers, Learn VBA Macro Coding with Word 2007 starts out by showing you how to write a very simple VBA program that runs in Word in the first lesson. The course does assume that you know how to use a computer and Word 2007, but it does not assume that you know anything about writing a computer program. If you want to know how to get more out of Word, this course is for you.
A reader asked how to sum the values in an Excel spreadsheet. He wanted to find the sum of the values in all cells in one column using a key value in a different column. This VBA program, written using Excel 2003 Visual Basic for Applications (VBA), does the trick.
Editing one Office 2003 document using VBA code in another requires some careful programming. In this article, several approaches to editing an Excel 2003 spreadsheet in a Word 2003 macro are explored to demonstrate the general approach on doing it.
The second lesson in a tutorial About using VBA - Visual Basic for Applications. This segment shows how to use VBA in Word. - Part 3
The second lesson in a tutorial About using VBA - Visual Basic for Applications. This segment shows how to use VBA in Word. - Part 2
The second lesson in a tutorial About using VBA - Visual Basic for Applications. This segment shows how to use VBA in Word. - Part 1
The fifth and concluding lesson of a series About using VBA - Visual Basic for Applications. This segment shows how to use VBA with Access and wraps up the series with some general observations.
An introduction level course in Visual Basic using VBA for Microsoft Word - Page 3
An Introduction to Word VBA - Visual Basic for Applications
Here's a fast tutorial for VBA, Microsoft's programming tool for Office and the choice of hundreds of third party software suppliers too. If you have tried VBA and you want to know more about how to use it, this is the tutorial for you.
