Multiple Excel Type Libraries

[James]

I am creating an Access 2007 application that will send over an array to
Excel in order to have a function performed on it and then will post the
answer back into the Access form. My question is, knowing that my customer
is running different versions of Excel including 2000, XP, and 2003, do I
need to create an app for each one of those versions by checking the box in
the reference section or can I simply create one application and click all
Excel type libraries from 2000 through 2007, write my VBA code and be done?

Thanks for your help!

 

[Douglas J. Steele]

Use Late Binding instead, so that you don't need to set any reference to
Excel at all.

Tony Toews has an introduction to the topic at
http://www.granite.ab.ca/access/latebinding.htm

 

[James]

Thanks Doug this worked just fine!

James

Use Late Binding instead, so that you don't need to set any reference to
Excel at all.

Tony Toews has an introduction to the topic at
http://www.granite.ab.ca/access/latebinding.htm