#3 Class definition EXCEL.APPLICATION is not found.

[Anonymous]

Using OpenOffice 3.0.1 on Windows Server 2003 trying to integrate OpenOffice with Made2Manage 5.60 SP2, a FoxPro 8.x compiled CRM/MRP/ERP application. I'm able to export reports to Excel 5.0 format but have now found that some of our reports output directly to Excel (for direct viewing) somehow. When this happens, I get a "Class definition EXCEL.APPLICATION is not found." I found an MS link indicating a registry key that defines the EXCEL.APPLICATION class that is not being found...

http://support.microsoft.com/kb/240794
HKEY_LOCAL_MACHINE\Software\Classes\Excel.Application\CLSID

This key is definitely missing. I copied this key from a working XP Pro system with MS Office Basic 2003 which got me past the initial error but then took me to another one. Using the key from the XP system, I figured, shouldn't be a problem because it only refers on to an Excel.Application.11 key which is properly in place on the 2003 system.

So, next error past the EXCEL.APPLICATION class issue... "Member APPLICATION does not evaluate to an object." And, after hitting Ignore and OK, this goes on to say "OLE error code 0x8002801d: Library not registered." three times.

Any ideas of how to get past this problem? I REALLY want to get this working. I've been with this company now for 3 months as their IT Engineer and have found that they have a wide variety of MS Office versions scattered throughout the environment and I'd like to use the opportunity to try to unify everyone using OpenOffice and then also Terminal Services where applicable. I've been watching for a tool to emerge like AutomateIT for maybe 2 years now. You're paving a powerful road to help get people weened off of M$ Office. Thanks! :)

[ApriorIT]

AutomateIT! installation correctly registers all own COM objects which emulate MSOffice objects.
Therefore after installing you will have these needed registry keys.
If the keys do not exist you should register AutomateIT COM servers manualy.
Please try to do the following:
You should do this from the AutomateIT! installation folder
1. Type in command line: ExcelClone /UnRegServer
2. Type in command line: Excel /RegServer
3. Type in command line: Excel /UnRegServer
4. Check the foolowing keys availability
[HKEY_CLASSES_ROOT\Excel.***************]
[HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}]
[HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}]
If they are present, delete them.
5. Type in command line: ExcelClone /RegServer
Try to launch test script.
Set ExcelApp = WScript.CreateObject("Excel.Application")
ExcelApp.Visible = TRUE
ExcelApp.WorkBooks.Add
ExcelApp.Cells(1, 1).Value = "AutomateIT!"