Jon -

Hate to sound dense, but your solution specifically references the xla.
Does that mean I have to check to Excel version and call xla or xlam,
depending?



"Jon Peltier" wrote:

If you use late binding, you don't need to reference either solver add-in:

http://peltiertech.com/Excel/SolverVBA.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Duke Carey" wrote in message
...
Has anyone a solution to reference issues such as this:

I was asked to create a tool using Solver for use by a co-worker & his
department. They are all using Office 2003 while I am on Office 2007.

My code must reference the 2007 solver add-in, Solver.xlam, while to run
on
their PCs it must reference solver.xla. Each round of testing requires
that
the tester go thru the steps of 'de-referencing' the xlam and referencing
the
xla.

Is there a technique for "conditional referencing" depending on the
version
of Excel?