Unable to load Microsoft Excel Automation Library

[CCB]

Good morning,
I recently updated Office 2010 to Office 2013, and then went back to Office 2010 due to compatibility issues.
Ever since, dumping data to Excel with mode=update produces the "Unable to load Microsoft Excel Automation Library" error.
Code snippet to recreate the error:

wfcreate a 1990 2000
series test=0
wfsave(type=excelxml, mode=update) a.xlsx @keep test

The same code without mode=update works fine. Repairing the Office installation does not help, and the Eviews addin appears to be installed and active in Excel. Any ideas on how to fix this?
Thanks and best regards,
Ulrich

[EViews Steve]

My guess is that Excel COM registration has been messed up on your machine.

Is Excel running and does it have that file open at the time you run with wfsave command?

I believe if Excel is shutdown, EViews will write the data directly to the file without using Excel COM Automation (thus avoiding the error you currently get). If Excel has the file open and has locked it, EViews then tries to send the data via COM automation to Excel. The progid of the object EViews is trying to create & use is "Excel.Application".

In any case, try having Excel restore it's registry settings by running the following:
(I found this in the following microsoft post: http://support.microsoft.com/kb/292491)

Code: Select all

"c:\program files\microsoft office\office\excel.exe" /regserver

You should adjust the path above to be correct for your version of Excel. Run this command in a DOS command window that has Admin rights.

Steve

[CCB]

If Excel is not open when using the wfsave with mode=update command, EViews either crashes or reports the same Automation Library error with about equal probability.
Restoring the registry unfortunately did not solve this issue.
I guess I will have to go for re-installing EViews, Office, both, or probably even wipe the whole system if that doesn't help.
Thanks!
Ulrich