Library tutorials & articles tagged with vba

• Understanding Open XML

  by Matt Nicholson

  Matt 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. vba, xml

• Inside Open XML

  by Matt Nicholson

  As 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. vba, xml

• OpenXML - Open for business

  by Matt Nicholson

  The new file format introduced with the 2007 Microsoft Office System opens up many business opportunities. Matt Nicholson finds out who is doing what. vba, xml

• Opening the package in OpenXML

  by Tim Anderson

  In the second part in this series on OpenXML, Tim Anderson explains how the new Packaging API helps you work with Office Open XML documents. vba, xml

• Read and write Open XML files (MS Office 2007)

  by Zeljko Svedic

  Learn how to read and write Open XML files in the new Microsoft Office 2007, with a particular examination of the Excel file format. .net, components, c#, vb.net

• Manipulate CorelDraw layers

  by tlosekoot

  Manipulate CorelDraw! layers using VBA vba

• VBA in FrontPage

  by Bill Burris

  How to create your own Macros in FrontPage; examples include altering headers across the site, adding code samples, and using msxml vba

• Handling Errors in VB/VBA/VBS/ASP

  by Mike J

  This 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. visual basic, vba

• VBA in Excel

  by James Crowley

  Want to know how to record and create Macros in Excel, apply formatting, add formulae and autofill values? Take a look at this extensive tutorial. vba