Reference Issues - Missing References

[Shane O]

Hello,

Is it possible to run a peice of code without checking to see if variables/objects/etc.. exist?

I want Excel to remove missing references and add the appropriote references based on what version of VBA is being used:

Please Login or Register  to view this content.

I want the above code to run before it does all the compiling checks.

The excel macro will be used on Windows 7 and Windows XP machines. For some reason, if a reference is missing, when I open the workbook, all it does is give me an error and then highlights a peice of common code (like Mid, or Trim).

[Shane O]

(sorry for the double-post, for some reason it won't let me edit - keeps timing out).

To simplify my question:

How do I remove all references that are 'MISSING'?