VBA in MS Access needs Excel reference

[MattSharp]

So I wrote some code in Access VBA to build a spreadsheet. It obviously needs a refernce added for MS Excel. The problem is when I give this to someone who doesn't have the same version of Excel it doesn't seem to work. Is there anyway aroundd this?

[DKenny]

Search this forum for "late binding". This is the best way to avoid these types of issues.

[DKenny]

The following post is a pretty good one, and has a link to an external site that explains the difference between early and late binding

http://www.vbforums.com/showthread.php?t=362347