Error 424: Set xlApp = CreateObject ("Excel.Application")

[FrozenMana]

The database in question is on a shared network and used by multiple people. The coding has been changed to use late binding due to multiple versions of Access being used to utilize this database.

One of the users is receiving the following error message:

Error 424: Object required

The line that shows up during the de-bug process is:

Set xlApp = CreateObject ("Excel.Application")

Any advise is welcome. All I have come across while trouble shooting refers to missing references in early binding.

 

[James Deckert]

How is xlApp defined?
what happens if you enter 'CreateObject ("Excel.Application")' into the immediate window?
Is there any difference between versions of Office with this computer?

 

[FrozenMana]

How is xlApp defined?
what happens if you enter 'CreateObject ("Excel.Application")' into the immediate window?
Is there any difference between versions of Office with this computer?

It just gives the same error message. There are other users that are able to use the database without issue with the same version of Office/Access as the user having the issue.

 

[zpy2]

try to run this code under EXCEL or Word VBA.
if still occurs error, I am afraid you have to reinstall your office to fix this problem.
your register probably has been destroyed.

 

[FrozenMana]

try to run this code under EXCEL or Word VBA.
if still occurs error, I am afraid you have to reinstall your office to fix this problem.
your register probably has been destroyed.

If that were the case wouldn't the other Access databases they use not work as well on their computer?

 

[James Deckert]

Do the other Access databases create Excel objects?
See if you can do a repair of Office before a reinstall.
I also like the suggestion of creating the Excel object in Excel or Word to see what happens.