Excel 2003 Workbook Project on Excel 2003 Standard Edition

Tomy Varghese

2010-02-23 12:29:03 UTC

Post by Tomy Varghese
Hi All,
I have created an Excel 2003 Workbook project. All is well with the
functionality till i try to use in Excel 2003 Standard Edition where it
freezes. Excel 2003 Addins work fine though.
http://www.microsoft.com/downloads/details.aspx?FamilyId=5E86CAB3-6FD6-4955-B979-E1676DB6B3CB&displaylang=en
…
…
Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System
…
…
• Application-level add-in projects for five Microsoft Office 2003
applications (Professional Edition and Standard Edition): Microsoft
Office Excel 2003, Microsoft Office Outlook 2003, Microsoft Office
PowerPoint 2003, Microsoft Office Visio 2003, and Microsoft Office Word
2003.
…
…
…
Is there any patch or workaround for this as not all clients will be
having the professional edition.
Thanks & Regards
Tomy

The Workaround (?) :

Already developed the logic in seperate C# class libraries so in the
case of Standard office 2003, call these dll's using VBA via a COM
wrapper (COM interop = true). Will have to replace the Windows Controls
with VBA controls so may not get a great look and feel, but
functionality is intact.
The disadvantage would be that the code would travel with the work book
causing problems during an upgrade, Not to mention increased calls
between COM & Dotnet World. [VBA to C# to COM (Excel)!!]

Any other ideas/opinions are welcome please.

Cheers!