Archive for the ‘Microsoft Office 2007’ Category

Automating Excel 2007 in C++ by Importing the Excel 2007 Type Library

July 21st, 2009

When I started trying to write automations for Excel 2007 using C++, I ran into problems right up front. I was trying to use #import to get to the type library for Excel 2007, and was importing what I thought was the correct file. The following was written for a C++ application in Visual Studio 2008 (VS2008), automating Excel 2007.
» More: Automating Excel 2007 in C++ by Importing the Excel 2007 Type Library

Access Microsoft Excel 2007 COM API through Microsoft Active Accessibility

July 15th, 2009

A couple days ago I showed you how to access the Microsoft Word 2007 COM API through Microsoft Active Accessibility (MSAA). Today, I’m going to switch it up just a little bit, and use the same method to access the Microsoft Excel 2007 COM API. Again, we’ll be using AccesssibleObjectFromWindow to get at the main Excel::Window object. From that object, you can obtain the Excel Application, and Excel Workbook objects. Some documentation from Microsoft can be found here.

» More: Access Microsoft Excel 2007 COM API through Microsoft Active Accessibility

Getting the COM object from HWND using AccessibleObjectFromWindow in Microsoft Word 2007

July 14th, 2009

After spending some time on this over the past few days, and sorting through the spotty documentation provided by Microsoft on Accessibility, I was able to get a handle on the COM object in Microsoft Word 2007.  It turns out to be pretty simple, and is actually in the documentation they provide here, but they don’t make it clear as day.  I intend to do that here.

» More: Getting the COM object from HWND using AccessibleObjectFromWindow in Microsoft Word 2007