Hi Paul,

You'll need to compile against the earliest version of Excel that your
application plans to run with. The object libraries are always forward
compatible, but very often not backward compatible. Other than this, late
binding is your only option.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Paul" wrote in message
...
I have just recently upgraded my office products to office
xp but I still have clients running my software using
earlier versions of the product. My software heavily
relies on automation in excel to produce reports. I ran
into a problem though with the saveas method in excel. I
compile against the 10.0 object and when run against the
9.0 object, my code blows up. I have resorted to using
late binding to get around this for now but would like to
know if there is something better as late binding doesn't
give compile errors.