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?
Printable View
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?
Search this forum for "late binding". This is the best way to avoid these types of issues.
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