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?

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?

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?

Jon - ignore my last message. My adult literacy class hasn't helped as much
as it should. The second reading of your site made it clear. Thanks for the
info.

"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?