Program Microsoft Office Applications
Using VBA in Office 2007
Microsoft decided to change just about everything in Office 2007 and VBA - Visual Basic for Applications - wasn't spared. This article covers how to get started programming VBA macros using the Office application Word 2007.
Software Development Recommendations for a Small Business
What a small business should do to automate their operation. I look at the real world issues that a small business should think about to give them the best chance of success.
Getting Started Using VBA: The Excel Working Partner
Writing VBA Programs in Excel is the next step up when you want to become a real Excel expert. You can do everything from the keyboard, or you can enlist the help of your computer to do things faster and smarter with Visual Basic for Applications programs to automate Excel. This article will get you started "from the ground up" even if you have...
Automating Microsoft Office Applications and Managing Processes - Part 2
About Visual Basic Class Instructions for Chapter 13 of the Complete Course for VB.NET covering Microsoft Office Applications and Managing Processes. - Part 2
Automating Microsoft Office Applications and Managing Processes - Part 1
About Visual Basic Class Instructions for Chapter 13 of the Complete Course for VB.NET covering Microsoft Office Applications and Managing Processes. - Part 1
Word Application Automation / Date and Time Calculation Using Bookmarks in VB
This program uses VB.NET and Word to complete a Word document with date calculations. In my "other" life, I'm a writer. I was recently thinking about books such as 1984 and 2001: A Space Odyssey that have been bypassed by the march of time. The idea of using Visual Basic to write an "eternal" story that would always be current came to me, so I wrtote the story and a program to update dates and times in it using bookmarks. The program uses WPF - Windows Presentation Foundation - as the GUI.
VBA - The Visual Basic Working Partner
An introduction to VBA, the language used to program Microsoft Office applications such as Word, Excel, and Access. This intro shows you what VBA is and how to get started using it.
VBA - The Access Working Partner
Access remains a key member of the Office family of Microsoft applications partly because you can use the built in Visual Basic language to program it. If you decide to go with VB.NET instead, you might be better off with SQL Server. But if you want to create a database customized with Visual Basic in the familiar Office environment, Access is...