VBA Tutorials & Articles
-
Understanding Open XML
by Matt NicholsonMatt Nicholson introduces a range of articles covering the new Ecma Office Open XML standard, as supported by 2007 Microsoft Office system. Find out how Open XML works, how to use it and what you can do with it.
-
Inside Open XML
by Matt NicholsonAs Matt Nicholson explains, Open XML is not just a new file format for the latest version of Microsoft Office, but an open standard capable of expressing any Word, Excel or PowerPoint document.
-
Registry
by James CrowleyHow to save your program preferences to the registry.
-
VBA in FrontPage
by Bill BurrisHow to create your own Macros in FrontPage; examples include altering headers across the site, adding code samples, and using msxml
-
OpenXML - Open for business
by Matt NicholsonThe new file format introduced with the 2007 Microsoft Office System opens up many business opportunities. Matt Nicholson finds out who is doing what.
-
Handling Errors in VB/VBA/VBS/ASP
by Mike JThis article will discuss some of the more basic and practical ways to solve general error handling in your Visual Basic applications and MS Office VBA modules. It is in many ways applicable to VBA, VBScript and ASP, in much based on the same syntax and practical solutions in your code.
-
Manipulate CorelDraw layers
by ThamarManipulate CorelDraw! layers using VBA
-
Developing for Office 2007
by Matt NicholsonThe forthcoming 2007 Microsoft Office System offers many new opportunities for software developers. Matt Nicholson looks at the new user interface and the Open XML file format, finds out what's happened to VSTO, and explores the possibilities opened up by SharePoint Server 2007 and Groove 2007.
-
Opening the package in OpenXML
by Tim AndersonIn the second part in this series on OpenXML, Tim Anderson explains how the new Packaging API helps you work with Office Open XML documents.
-
Read and write Open XML files (MS Office 2007)
by Zeljko SvedicLearn how to read and write Open XML files in the new Microsoft Office 2007, with a particular examination of the Excel file format.
-
VSA Scripting in .NET
by Mark BellesUsing Visual Studio for Applications to add scripting capabilities to your .NET apps.
-
VBA in Excel
by James CrowleyWant to know how to record and create Macros in Excel, apply formatting, add formulae and autofill values? Take a look at this extensive tutorial.
-
VB Editions
by James CrowleyThis tutorial describes the different versions and editions of VB available, and what you can do with them.
