Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Accessing the OLE Registry
Hello,
I'm hoping someone out there can help me. Environment: Win2K WS, Win2K Domain User, Excel97 (Standalone user) I have a macro that creates a userform. This code worked before, but a recent regression test showed that it was no longer working. We upgraded from NT 4.0 to Win2K (Server and nodes) since the code was originally written. The code: Dim x as object Application.VBE.MainWindow.Visible = False Set TempForm = ThisWorkbook.VBProject.VBComponents.Add(3) Stepping through with the debugger, the following can be seen with the cursor on the second statement: Application.VBE.MainWindow... = <Method 'VBE' of object '_Application' failed. Additional Error Information gained by Err is: Runtime error -2147319780 (8002801c) Automation Error Error Accessing the OLE registry. I believe this is some kind of permission problem, but I can't find it. The code does work if I am logged in as administrator, however we would like to avoid this as a requirement. I've tried a visual check of permission problems using regedt32. Regmon did not help, since you have to be logged in as administrator to use it, but the problem does not show up with an administrator user. I've even tried a reformat & new install of Win2K WS and Excel 97. I would appreciate any help in this matter... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error 1406 setup cannot write to registry | Excel Discussion (Misc queries) | |||
Compile error when accessing a spreadsheet | Excel Worksheet Functions | |||
error accessing system registry | Excel Discussion (Misc queries) | |||
Error 1402. Setup cannot open the registry key. | Excel Discussion (Misc queries) | |||
error accessing a protected worksheet | Excel Worksheet Functions |