Archive for July, 2009

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

Easy to use, yet powerful PHP E-mail Class

July 21st, 2009

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!
» More: Easy to use, yet powerful PHP E-mail Class

HTA Progress Bar using VBScript and JavaScript

July 17th, 2009

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.
» More: HTA Progress Bar using VBScript and JavaScript