View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default referencing Solver.xlam vs. Solver.xla - 2007 vs. 2003

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?