Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DCOM Configuration: "The operation completed successfully"
(Apologies if this has been covered before)
I have several scripts that automate the creation of Excel workbooks, that are kicked off by the SQL Server Agent. Up until today, everything ran as expected. However, today, the scripts were failing silently. I went to check the DCOM permissions (dcomcnfg), but when I selected "Microsoft Excel Application" from the list and clicked the Properties button, I got a message box saying "The operation completed successfully", and an OK button - not the Properties tabs I was expecting. According to MS KB article 288367 (http://support.microsoft.com/kb/ 288367), "How to configure Office applications to run under a specific user account", the following registry key should exist: Key: HKEY_CLASSES_ROOT\AppID\EXCEL.EXE AppID: {00020812-0000-0000-C000-000000000046} I mis-read this, and thought it meant to create the registry key: HKEY_CLASSES_ROOT\AppID\{00020812-0000-0000-C000-000000000046} which I did, and that was the solution, my scripts started working again! I tried deleting my 'incorrect' key: scripts stop working. Tried putting in the 'correct' MS key: scripts not working. Put in the 'incorrect' key again: scripts work ok! So really, I'm posting this (a) because it might help someone in the future, and (b) to ask if anyone has any ideas WHY this problem might have occurred, and why the MS suggestion doesn't work, but my mis- reading of it does! (Normally, I expect problems after an MS update, but that wasn't the case here, so I'm even more intrigued than normal...!) Regards, Nate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"ignoring" hidden cells in a copy/paste operation | Excel Discussion (Misc queries) | |||
Odd error - "This operation requires merged cells..." | New Users to Excel | |||
how can I get the word "draft" printed over my completed workshee. | Excel Discussion (Misc queries) | |||
Excel RTD with DCOM -- "Class not registered" error | Excel Programming | |||
"operation is not allowed when the object is closed" error when us | Excel Programming |