Microsoft Excel - Runtime Error '-2747024770 (8007007e)': Automation error The specific

Asked By vkrishna on 05-Sep-11 01:43 AM

when i have connect to oracle using excel vba the following error is arised
Runtime Error '-2747024770 (8007007e)': Automation error The specific module could not be found
how can i solve this please help
Thanks in advance

Regards,
vamsi

smr replied to vkrishna on 05-Sep-11 01:48 AM

HI

Just register scrrun.

regsvr32 %windir%\system32\scrrun.dll

It worked for me.

Reena Jain replied to vkrishna on 05-Sep-11 01:53 AM

Hi,

It seems that there was some kind of problem with scrun.dll. just try to register the dll again, using:

regsvr32 C:\WINDOWS\System32\Scrrun.dll

in the CMD prompt

Anoop S replied to vkrishna on 05-Sep-11 03:01 AM

Cause
This error is caused by a problem with the Microsoft Script Runtime Library.

Solution or Workaround
Manually register the Microsoft Script Runtime Library by following these steps:

   1. Click Start > Run.
   2. Type CMD and click OK.
   3. Type the following and press the Enter key:

    regsvr32 "c:\windows\system32\scrrun.dll"

   4. Close out of the Command Prompt and restart the ArcGIS Desktop installation.