ActiveX failure to get Excel object

[Monterey_Manzer]

Hi Everyone,

Okay I am having a rather weird and very frustrating problem and I hoping someone else has met with conquered this little beasty. Here's the general situation. I have an Access dBase that is used to house many administrative trackers. These are all replacements of previously used Excel versions and, since other parties with whom we do business are used to those Excel versions, all my reports include an Export to Excel button. This button utilizes the DoCmd.OutputTo command to generate an Excel spreadsheet and then I call one of two Excel formatting macro that I have written (depending on report filtering options). These Excel macros always begin with the same two lines of code as shown below (fName is a passed argument that corresponds to the file name of the Excel file):

Set xl = GetObject(, "Excel.Application")
Set xlWb = xl.Workbooks(fName)

Now here's the problem: These two lines of code, along with the rest of the macros, work just fine on my computer. They work just fine on the computer of the head administrator with whom I work to develop Access solutions. However, two of the administrators here receive an error "ActiveX component can't create object". Now we all use identical computers with what should be identical settings so I am at a loss as to how to fix this problem. If anyone has any suggestions I would greatly appreciate it.

Thanks!


Ryan

[June7]

Maybe their Access install is missing something. Reinstall Access?

[mrojas]

I would open the database in one of the computers that do work, switch to design mode (Alt+F11) and from the Tools menu select References.
Take not of all "checked" references (libraries, etc.)
Do the same on the computer that generates the error, and compare the references. Most likely you'll find out that you're missing a library; OLE Automation, Microsoft Office xx.x Object Library, Microsoft Excel xx.x Object Library or similar.

[Monterey_Manzer]

Well I took a look at the Access menu options on the machines that didn't work and I think I've found the problem. When I open the Tools menu, the References selection is greyed out and unselectable. Perhaps their install of Access was missing this key part. Unfortunately none of us in the office have administrator privileges on these machines and I will have to push a request for a re-install to the group that manages our computer resources. If that fixes the problem i will mark this thread as solved.