• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 23240
  • Last Modified:

stdole32.tlb error in Excel 2007

Whenever I open Microsoft Excel 2007, I get a dialog box that says "stdole32.tlb" (without the quotes).  There is no error message or anything else written on the box except an "OK" button.  When I press OK, Excel runs normally.  The next time I opn Excel, same thing.  I have tried uninstall/reinstall and transferring the stdole32.tlb file from one computer to another (it won't overwrite, because Vista says I don't have permission).

My computer runs Vista 64 bit.
0
MarkF2
Asked:
MarkF2
3 Solutions
 
ahmed-heshamCommented:
Dear Mark,
1. Determine which stdole files are missing.
  • Click StartFindFiles or Folders.
  • In the All or part of the file name field, type stdole*.tlb to search for the missing files.
  • In the Look in field, click Drive C.
  • Write down which files are missing. You will use the file names in the following steps.
2. Extract the missing stdole files from a cabinet file using the Expand utility.
  • Click StartRun.
  • Type CMD. Click OK.
  • Change to the root folder of drive C, type cd\ or c:, and press ENTER.
  • Insert the Windows Installation CD.
  • Type expand cd_drive_letter:\i386\filename.tl_ drive:\Windows\system32\filename.tlb, and press ENTER, where cd_drive_letter is your CD drive, filename is the name of one of the missing stdole files (stdole32, stdole2, stdole) that you want to expand, and drive is the letter of the drive where Windows is installed. For example:
    expand D:\i386\stdole32.tl_ C:\Windows\System32\stdole32.tlb
  • Repeat the previous step for each missing stdole file.
  • Type exit.
  • Restart your computer.
0
 
LocklearCommented:
Well, I believe that this error (stdole32.tlb) is caused by wrong permissions for HKEY_CLASSES_ROOT key in registry.
Please check this key in registry:
 - run regedit, and right-click HKEY_CLASSES_ROOT (first one in the tree) and select Permissions
 - check if Administrators and Users groups have full permissions to this key, if not, follow please this instruction http://dventhusiast.com/problems/vista-office-2007-installation-problems-stdole32tlb/
0
 
ChenyCommented:
this file is not missing. It was located in C:\Windows\System32\stdole32.tlb.
I have the same problem when I start Excel 2007 in Vista.

I'm also searching solution.
0
 
ChenyCommented:
This issue is very difficult to fix.

I have the same problem as you before. I found out HKEY_CLASSES_ROOT permissions display blank. That mean Registry has problem. And this is very difficult to fix. If you change permissions wrong, you won't be able to start windows again or you cannot execute *.exe files. That's what happen to me.

I have to re-install entire windows and applications.

Normally, the HKEY_CLASSES_ROOT permissions should be
Administrations -> Full
System -> Full
Creator Owner -> Special Permissions.
Power Users -> Read
Users -> Read
0
 
lovepashahCommented:
To fix this isue Open regedit rightclick on HKEY_Classes_Root Select Permissions if you see, no permissions have been assigned to HKEY_CLASSES_ROOT.  This is cause of the Office 2007 installation problems, as well as potentially a lot of other problems you are having with installing products.

The very first thing you need to do is backup your registry.  There is a good walkthrough of doing this here. (http://www.adamsdvds.co.uk/tutorials/vista/regedit/backup.php)

Next, you need to download a Microsoft tool called SubInACL (http://www.microsoft.com/downloads/details.aspx?FamilyID=E8BA3E56-D8FE-4A91-93CF-ED6985E3927B&displaylang=en )
and install it.

If your computer is the same as mine, it should install into the following folder:

c:program filesWindows Resource KitsTools

Open your text editor and paste in the following code:

subinacl /subkeyreg HKEY_CURRENT_USER /grant=administrators=f /grant=system=f /grant=restricted=r /grant=YOURUSERNAME=f /grant=restricted=r /setowner=administrators
subinacl /keyreg HKEY_CURRENT_USER /grant=administrators=f /grant=system=f /grant=restricted=r /grant=YOURUSERNAME=f /grant=restricted=r /setowner=administrators

subinacl /subkeyreg HKEY_LOCAL_MACHINE /grant=administrators=f /grant=system=f /grant=users=r /grant=everyone=r /setowner=administrators
subinacl /keyreg HKEY_LOCAL_MACHINE /grant=administrators=f /grant=system=f /grant=users=r /grant=everyone=r /setowner=administrators

subinacl /subkeyreg HKEY_CLASSES_ROOT /grant=administrators=f /grant=system=f /grant=users=r /setowner=administrators
subinacl /keyreg HKEY_CLASSES_ROOT /grant=administrators=f /grant=system=f /grant=users=r /setowner=administrators

Save the file in the same folder as SubinACL.exe as officefix.cmd.

Now, edit the file by replacing the following text:

YOURUSERNAME  replace with your computer username.

Run the Officefix.cmd  after completing you will that permissions have assigned properly.

Still rightclick on you C drive go to properties and security tab and see all the id's listed there the same id's should be there in HKEY_CLASSES_Root Permission if not please assign.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now