Missing reference

[Zygor]

Before anyone suggests I look in our archives...I have.

I just want to make sure I didn't miss something.

I have a database on a server. Each user has a batch file that copies the database to their C: drive. (Speed is a major issue, so running it from the server is a NO go)

My dilema - The reference I use is to Excel 11, and half my population has Excel 10. I check the only reference I have, 10 and it doesn't work on thier PCs. I read there is no way to uncheck a missing reference and then add in the correct one. Is this correct?

 

[Remou]

A common solution to this problem is to use 'late binding', that is:

[tt]Dim xl As Object

Set xl=CreateObject("Excel.Application")[/tt]

This means that you do not need a reference to the library, however, you will need to change any built-in constants to values.

Some people recommend developing with a reference library and changing to late binding for the release copy.