Missing Office 11.dll

[dan231]

I was trying to uninstall office 2007 trial manually and found a reference that said to uncheck the bindings for Office 12 in Access.

I unchecked the office 11.dll by mistake in the available references and I can't find what .dll I need to recheck or reinstall. I looked and don't see Office 11 listed here.

Does any one know the name of this dll?

 

[darbid]

Maybe your question is harder then I understand and I do not refer to Office 11.0 I only make references to the individual applications like Word or Excel - but the .dll you are looking for might be in or around here

C:\Program Files\Common Files\Microsoft Shared\OFFICE11

 

[dan231]

I'll check that, thank you.

I have not been seeing any usability issues, so I may be ok either way.

 

[darbid]

I have not been seeing any usability issues, so I may be ok either way.

I have Excel, Outlook, Word and Powerpoint automated from Access and i do not use it as a reference. I also do not use Office 12.0. So I am not sure when you use this either.

 

[dan231]

It was listed and I unchecked by mistake. I thought I must have needed it because it was there previously.

 

[dan231]

I am missing something...
I am getting a debug error when the db is trying to open Word.

Set appWord = CreateObject("Word.Application")

I did add the *.olb files located in MS Office/Office11

 

[darbid]

I am missing something...
I am getting a debug error when the db is trying to open Word.
Set appWord = CreateObject("Word.Application")
I did add the *.olb files located in MS Office/Office11

I am not sure this has to do with the references as Access would probably have complained before then.

How are your declaring appWord?
When exactly are you getting the error?
what is the error message?

Here is what I would use to get a handle on the word application

On Error Resume Next
   Set appWord = GetObject(, "Word.Application")
   If Err.Number = 429 Then
      'Word is not running; creating a Word object
      Set appWord = CreateObject("Word.Application")
      Err.Clear
   End If

 

[dan231]

The reason I think I messed it up is this used to work fine until I unchecked that reference.

The error is:

Run-time '48':
Error in loading DLL

 

[darbid]

Sorry Dan but I cannot say that I know what your problem is. But I will give some suggestions -

what exactly do you have referenced? What is its name and what file name does it have? Where is it?

what are the answers to my other questions above.

Generally - http://msdn.microsoft.com/en-us/library/2c4wchf4(VS.80).aspx

Error in loading DLL (Visual Basic)

A dynamic-link library (DLL) is a library specified in the Lib clause of a Declare statement. Possible causes for this error include:

• The file is not DLL executable.
• The file is not a Microsoft Windows DLL.
• The DLL references another DLL that is not present.
• The DLL or referenced DLL is not in a directory specified in the path.

To correct this error

• If the file is a source-text file and therefore not DLL executable, it must be compiled and linked to a DLL-executable form.
• If the file is not a Microsoft Windows DLL, obtain the Microsoft Windows equivalent.
• If the DLL references another DLL that is not present, obtain the referenced DLL and make it available.
• If the DLL or referenced DLL is not in a directory specified by the path, move the DLL to a referenced directory.

I am going to make a wild wild guess that maybe the .dll's you now have and the .dll's that are in your registry may be different. For example upon the install of 2007 it updated .dlls to Office12 (i think) then you uninstalled it which deleted your files there but failed to tell your registry that it should now look at C:\Program Files\Common Files\Microsoft Shared\OFFICE11 again.

For example on my computer I have OFFICE11 because I have 2003 but OFFICE12 is there because I think that is for compatibility packs that have been added to my computer.

I am not an expert enough to suggest this to you but maybe you should consider a repair of office 2003 which you can do with your office CD. I did that once for Access. The next more drastic method would be to re-install word so that all these issues with the registry bla bla would be put to rest.

 

[dan231]

This all started because I tried to uninstall Office 2007 trial. It didn't work 100% so I went through the manual uninstall which had me due lots of stuff.

I just tried a repair of Office, which told me it failed due to a office source engine error. I looked it up and it said the ose.exe service was off or missing.

I checked to see if it was off, because the manual uninstall had me turn this off. It was not there, so it said the fix to that was to reinstall office, which I did but it's still not working.

I think I unchecked the office 11.dll, but I can't recall what the actual name was.

The code in the debugger after the error is:

Set appWord = CreateObject("Word.Application")
    appWord.Documents.Open strMailMergeDocName
    appWord.Visible = True

I have these currenlty referenced:
Visual Basic for applications
MS Access 11.0 Object Lib - OFFICE11\MSACC.OLB
OLE Automation - system32\STDOLE2.TLB
MS ActiveX Data Objects 2.1 Lib - System\ado\msado21.tlb
MS DOA 3.6 Object Lib - MS Shared\DAO\Dao360?
MS Word 11.0 Object Lib - OFFICE11\MSWORD.OLB

 

[darbid]

This all started because I tried to uninstall Office 2007 trial. It didn't work 100% so I went through the manual uninstall which had me due lots of stuff.

I just tried a repair of Office, which told me it failed due to a office source engine error. I looked it up and it said the ose.exe service was off or missing.

I checked to see if it was off, because the manual uninstall had me turn this off. It was not there, so it said the fix to that was to reinstall office, which I did but it's still not working.

This is way beyond me. But I think this is your problem and not with your code or Access. I would be working on getting a clean working error free office.

MS Word 11.0 Object Lib - OFFICE11\MSWORD.OLB

That is what I have. But if your registry is still thinking you have Office 2007 components then you are going to have problems.

I am sorry but I have not much more for you.

 

[dan231]

Thank you for your help - it is very much appreciated.

 

[dan231]

I could not fix this by uninstalling office alone. I restored my pc back to factory and am still in the process of reinstalling all my software and ms updates. But I did test it already and it works now.

stupid registry

 

[darbid]

I could not fix this by uninstalling office alone. I restored my pc back to factory and am still in the process of reinstalling all my software and ms updates. But I did test it already and it works now.

stupid registry

Ahhhhhh if I had of known you were thinking that I would have suggested a Registry Cleaner eg RegClean - But as they are dangerous things I do not like suggesting it. I have used one twice and the immediate disadvantages were zero. Later I noticed that it plays with little settings - especially with outlook for some reason - but they are so little it would be hard to prove that it was actually caused by RegClean.

 

[dan231]

I tried cleaners with no results.
I did all I could think of. I copied all Office11\1033 files, shared files, etc and tried to re register

I did a last ditch effort and restored. It's working now, so what has been done can't be undone.