If you create an xla (or xlam) file in Excel 2007 and add a VBA project
reference to Solver.XLAM using Tools-References, the xla (or xlam) file will
crash Excel when it is loaded. You must also add a VBA module (e.g.,
Module1) to the addin and place a dummy routine in the module such as:

Sub Test()
End Sub

Has anyone else experienced this problem with Excel 2007?

You mean you have an add-in that otherwise has no code?

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


"Michael" wrote in message
...
If you create an xla (or xlam) file in Excel 2007 and add a VBA project
reference to Solver.XLAM using Tools-References, the xla (or xlam) file
will
crash Excel when it is loaded. You must also add a VBA module (e.g.,
Module1) to the addin and place a dummy routine in the module such as:

Sub Test()
End Sub

Has anyone else experienced this problem with Excel 2007?

Of course not. It happens from the most complicated case to the simplest
case of no code being present. I simply thought that would be easier to
reproduce for problem resolution.

Michael

"Jon Peltier" wrote:

You mean you have an add-in that otherwise has no code?

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


"Michael" wrote in message
...
If you create an xla (or xlam) file in Excel 2007 and add a VBA project
reference to Solver.XLAM using Tools-References, the xla (or xlam) file
will
crash Excel when it is loaded. You must also add a VBA module (e.g.,
Module1) to the addin and place a dummy routine in the module such as:

Sub Test()
End Sub

Has anyone else experienced this problem with Excel 2007?

I haven't used Solver much in Excel 2007 yet, so I can't say anything too
profound. In any version of Excel, I avoid setting the Solver reference,
because I don't know who might use the workbook, on what version of Excel.
It's not as elegant, but I've found that it's much more robust, to use
Application.Run to invoke Solver, as I describe in this article:

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

YMMV.

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


"Michael" wrote in message
...
Of course not. It happens from the most complicated case to the simplest
case of no code being present. I simply thought that would be easier to
reproduce for problem resolution.

Michael

"Jon Peltier" wrote:

You mean you have an add-in that otherwise has no code?

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


"Michael" wrote in message
...
If you create an xla (or xlam) file in Excel 2007 and add a VBA project
reference to Solver.XLAM using Tools-References, the xla (or xlam)
file
will
crash Excel when it is loaded. You must also add a VBA module (e.g.,
Module1) to the addin and place a dummy routine in the module such as:

Sub Test()
End Sub

Has anyone else experienced this problem with Excel 2007?

I'm familiar with using late binding as well but I already have many xla's
that use early binding and don't really care to change them if I don't have
to. It's not that I'm lazy but I have other things to do as well. I would
not expect this to fail in the newer version.

Michael

"Jon Peltier" wrote:

I haven't used Solver much in Excel 2007 yet, so I can't say anything too
profound. In any version of Excel, I avoid setting the Solver reference,
because I don't know who might use the workbook, on what version of Excel.
It's not as elegant, but I've found that it's much more robust, to use
Application.Run to invoke Solver, as I describe in this article:

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

YMMV.

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


"Michael" wrote in message
...
Of course not. It happens from the most complicated case to the simplest
case of no code being present. I simply thought that would be easier to
reproduce for problem resolution.

Michael

"Jon Peltier" wrote:

You mean you have an add-in that otherwise has no code?

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


"Michael" wrote in message
...
If you create an xla (or xlam) file in Excel 2007 and add a VBA project
reference to Solver.XLAM using Tools-References, the xla (or xlam)
file
will
crash Excel when it is loaded. You must also add a VBA module (e.g.,
Module1) to the addin and place a dummy routine in the module such as:

Sub Test()
End Sub

Has anyone else experienced this problem with Excel 2007?

It's not a major change if all you're changing is how Solver is handled.

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


"Michael" wrote in message
...
I'm familiar with using late binding as well but I already have many xla's
that use early binding and don't really care to change them if I don't
have
to. It's not that I'm lazy but I have other things to do as well. I
would
not expect this to fail in the newer version.

Michael

"Jon Peltier" wrote:

I haven't used Solver much in Excel 2007 yet, so I can't say anything too
profound. In any version of Excel, I avoid setting the Solver reference,
because I don't know who might use the workbook, on what version of
Excel.
It's not as elegant, but I've found that it's much more robust, to use
Application.Run to invoke Solver, as I describe in this article:

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

YMMV.

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


"Michael" wrote in message
...
Of course not. It happens from the most complicated case to the
simplest
case of no code being present. I simply thought that would be easier
to
reproduce for problem resolution.

Michael

"Jon Peltier" wrote:

You mean you have an add-in that otherwise has no code?

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


"Michael" wrote in message
...
If you create an xla (or xlam) file in Excel 2007 and add a VBA
project
reference to Solver.XLAM using Tools-References, the xla (or xlam)
file
will
crash Excel when it is loaded. You must also add a VBA module
(e.g.,
Module1) to the addin and place a dummy routine in the module such
as:

Sub Test()
End Sub

Has anyone else experienced this problem with Excel 2007?