I downloaded the Example 2 again, and it worked. My previous download must
have been corrupted somehow.

Your right, the code sniipet <<Workbooks("MyAddIns.xlam").open

is not part of your Example 2. It was only meant to be a generic add-in
open statement.

"Ron de Bruin" wrote:

Do you have the same problem when you open the add-in from the download ?

Btw: This is not the add-in of example 2
Workbooks("MyAddIns.xlam").open


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"joeeng" wrote in message ...
It works when manually loading but not using code to open

"Jim Rech" wrote:

manually loading
Workbooks("MyAddIns.xlam").open

Which is it? Are you manually loading or using code?

--
Jim
"joeeng" wrote in message
...
|I was under the impression that manually loading .xlam files in Excel 2007
|
| i.e., Workbooks("MyAddIns.xlam").open
|
| would activate it as an add-in. It does not seem to be the case, though.
|
| Am I missing something?