Article Preview
Buy Now
FEATURE
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):
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.