K
Kevin
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...
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...