Excel 2007 Add-ins

[joeeng]

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?

 

[Ron de Bruin]

Hi joeeng

Why do you think it is not loaded as a add-in ?

A add-in is a hidden workbook

 

[joeeng]

It is supposed to add a new group to the ribbon, but doesn't. When I
manually add the .xlam file to the add-in list, it works. If I just open the
file it does not.

 

[Ron de Bruin]

This is very strange
There is no differents in loading it with the Add-in list or open it manual.

You can send me the file private and I take a look

 

[joeeng]

I am actually trying your Example 2 from "Avoiding Two Versions" article. I
cannot get it to work the way you describe that it should. I simply is not
adding the "Test Tab".

 

[Jim Rech]

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

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

 

[Ron de Bruin]

The download on the page is working OK
http://www.rondebruin.nl/compatiblemenu.htm

What have you changed ?

 

[joeeng]

It works when manually loading but not using code to open

 

[Ron de Bruin]

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

 

[Jim Rech]

It probably has a Sub Autpen in it. Autpen does not run when opened
by macro. It has to be forced to run:

Workbooks.Open "MyAddIns.xlam"
Workbooks("MyAddIns.xlam").RunAutoMacros xlAutoOpen

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

 

[Ron de Bruin]

Hi Jim

The OP say

I am actually trying your Example 2 from "Avoiding Two Versions" article.

There is only RibbonX in the add-in of that example

 

[Jim Rech]

I am actually trying your Example 2 from "Avoiding Two Versions" article.

I missed that.

So he's opening our XL11WB.XLS and it's loading HasRibbonX.xlam and the
ribbon changes are not occurring? I'd like to know how to do that. I'd
guess the xlam is not opening maybe because the open workbook_code in
XL11WB.XLS isn't running.

--
Jim
| Hi Jim
|
| The OP say
| >I am actually trying your Example 2 from "Avoiding Two Versions" article.
|
| There is only RibbonX in the add-in of that example
|
|
| --
|
| Regards Ron de Bruin
| http://www.rondebruin.nl/tips.htm
|
|
| > It probably has a Sub Autpen in it. Autpen does not run when
opened
| > by macro. It has to be forced to run:
| >
| > Workbooks.Open "MyAddIns.xlam"
| > Workbooks("MyAddIns.xlam").RunAutoMacros xlAutoOpen
| >
| > --
| > Jim
| > | > | 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
| > | > | > | > |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?
| > | >
| > | >
| >

 

[Ron de Bruin]

Hi Jim

I'd guess the xlam is not opening maybe because the open workbook_code in
XL11WB.XLS isn't running.

Yes

 

[joeeng]

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.

 

[joeeng]

After downloading the Example a second time, it works. The first download
must have been corrupted somehow.

Thnaks for your prompt attention.