Runtime Error - asks for excel.exe reference

[Guest]

I have an app that's created in 2003. I'm trying to make a runtime of
it. It works just fine on my computer but not on machines that don't
have 2003. The error message says "Your database or project contains a
missing or broken reference to the file EXCEL.EXE' ver 1.5 To ensure
that your database works properly, you must fix this reference.

I am referencing the MS excel 11.0 library. If I uncheck this, my app works
fine, however I need to refence this library in order for a certain function
to work.

Help

 

[Morten Snedker]

Checking the library and referencing to this, is called "early
binding" and is not the proper way. It's not proper because of the
problem you just encountered.

Instead you should use the method of late binding. Visit Google for
plenty of help:
http://groups.google.dk/groups?q=excel+late+binding&hl=us

Regards /Snedker

 

[Guest]

Thanks So much Morten. I wasn't familiar with that and will try it.