how to set references

[v5652]

hello everybody,

i have used an excel graph in my application. but i have created the application in access 2003 and graph in excel 2003 and user has office 2000 version. so because of version problem the application couldn't get start, because it shows 'Missing microsoft excel 11.0 object library'.
i have given a password to my vba code.
is it possible to set these refrences programatically.
if any suggestions pl...
thanks in advance.

 

[dhookom]

You might want to try using late binding so your code isn't dependent on a specific flavor of the object library. Search on "VBA Late Binding" prior to posting back.

Duane
Hook'D on Access
MS Access MVP