Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview

Buy Now

Issue 8.3


Office Reporter

Using Microsoft Office as a Reporting Tool in REALbasic

Issue: 8.3 (March/April 2010)
Author: Craig Boyd
Author Bio: Intermediate
Article Description: No description available.
Article Length (in bytes): 22,272
Starting Page Number: 15
Article Number: 8309
Resource File(s):

Download Icon 8309.zip Updated: 2010-03-01 14:10:06

Related Link(s): None

Excerpt of article text...

There has been a lot of focus this year on reporting for REALbasic. This is not a bad thing since this has been an area that needs a lot of attention. During this article I hope to show you how to easily incorporate Microsoft Office into your reporting options.

Whether you love, hate, or don't care about Microsoft you have to admit that within the Windows' world, Microsoft Office is now a part of life and definitely here to stay. So using it as a reporting tool for Windows is a reasonable choice.

Currently, REALbasic only supports interaction with Microsoft Office on the Windows platform and it already comes with some good Office examples. These can be found in the Examples\Office Automation folder. There is a REALbasic example for Word, Excel, and PowerPoint. The good news is that REALbasic has done a lot of heavy lifting for us. The wonderful folks at REAL Software have prebuilt most, if not all, of the classes and objects we need in order to work nicely with Office.

Introduction to Office Automation

Since PowerPoint really is not very useful as a reporting tool, I am going to focus on Excel and Word. For this article I am using REALbasic (RB) 2009r5.1 and Microsoft Office 2007. This code should work the same for the last version or two of Office and most likely a couple years worth of RB releases.

...End of Excerpt. Please purchase the magazine to read the full article.