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

July 21, 2009 No comments »

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.
» Read more: Automating Excel 2007 in C++ by Importing the Excel 2007 Type Library

Sphere: Related Content

Easy to use, yet powerful PHP E-mail Class

No comments »

This is a pretty robust PHP Email class that I wrote a few years back. Has the capability to do text or html e-mails with multiple attachments. Enjoy!
» Read more: Easy to use, yet powerful PHP E-mail Class

Sphere: Related Content

HTA Progress Bar using VBScript and JavaScript

July 17, 2009 No comments »

I was informed after my last post that using HTA (HTML Applications) to display a progress bar in VBScript is much more efficient than using InternetExplorer.Application within a VBScript. Having never used HTA before, I immediately set out to learn a bit and see what I could come up with.

My initial thoughts are mixed, as you can not run and interact with an HTA from a VBScript file.  This requires you to wrap your VBScript code in whatever HTML Application you are writing. This greatly limits re-usability, enough so that the increase in performance may not warrant using an HTA for a progress bar in most cases.
» Read more: HTA Progress Bar using VBScript and JavaScript

Sphere: Related Content