|
Excel 2007 Add-ins
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? |
Excel 2007 Add-ins
Hi joeeng
Why do you think it is not loaded as a add-in ? A add-in is a hidden workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "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? |
Excel 2007 Add-ins
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" wrote: Hi joeeng Why do you think it is not loaded as a add-in ? A add-in is a hidden workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "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? |
Excel 2007 Add-ins
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "joeeng" wrote in message ... 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" wrote: Hi joeeng Why do you think it is not loaded as a add-in ? A add-in is a hidden workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "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? |
Excel 2007 Add-ins
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". "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "joeeng" wrote in message ... 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" wrote: Hi joeeng Why do you think it is not loaded as a add-in ? A add-in is a hidden workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "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? |
Excel 2007 Add-ins
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? |
Excel 2007 Add-ins
The download on the page is working OK
http://www.rondebruin.nl/compatiblemenu.htm What have you changed ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "joeeng" wrote in message ... 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". "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "joeeng" wrote in message ... 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" wrote: Hi joeeng Why do you think it is not loaded as a add-in ? A add-in is a hidden workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "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? |
Excel 2007 Add-ins
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? |
Excel 2007 Add-ins
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? |
Excel 2007 Add-ins
It probably has a Sub Auto_Open in it. Auto_Open does not run when opened
by macro. It has to be forced to run: Workbooks.Open "MyAddIns.xlam" Workbooks("MyAddIns.xlam").RunAutoMacros xlAutoOpen -- Jim "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? | | |
Excel 2007 Add-ins
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 "Jim Rech" wrote in message ... It probably has a Sub Auto_Open in it. Auto_Open does not run when opened by macro. It has to be forced to run: Workbooks.Open "MyAddIns.xlam" Workbooks("MyAddIns.xlam").RunAutoMacros xlAutoOpen -- Jim "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? | | |
Excel 2007 Add-ins
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 "Ron de Bruin" wrote in message ... | 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 | | | "Jim Rech" wrote in message ... | It probably has a Sub Auto_Open in it. Auto_Open does not run when opened | by macro. It has to be forced to run: | | Workbooks.Open "MyAddIns.xlam" | Workbooks("MyAddIns.xlam").RunAutoMacros xlAutoOpen | | -- | Jim | "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? | | | | | |
Excel 2007 Add-ins
Hi Jim
I'd guess the xlam is not opening maybe because the open workbook_code in XL11WB.XLS isn't running. Yes -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jim Rech" wrote in message ... 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 "Ron de Bruin" wrote in message ... | 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 | | | "Jim Rech" wrote in message ... | It probably has a Sub Auto_Open in it. Auto_Open does not run when opened | by macro. It has to be forced to run: | | Workbooks.Open "MyAddIns.xlam" | Workbooks("MyAddIns.xlam").RunAutoMacros xlAutoOpen | | -- | Jim | "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? | | | | | |
Excel 2007 Add-ins
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? |
Excel 2007 Add-ins
After downloading the Example a second time, it works. The first download
must have been corrupted somehow. Thnaks for your prompt attention. "Ron de Bruin" wrote: Hi Jim I'd guess the xlam is not opening maybe because the open workbook_code in XL11WB.XLS isn't running. Yes -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jim Rech" wrote in message ... 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 "Ron de Bruin" wrote in message ... | 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 | | | "Jim Rech" wrote in message ... | It probably has a Sub Auto_Open in it. Auto_Open does not run when opened | by macro. It has to be forced to run: | | Workbooks.Open "MyAddIns.xlam" | Workbooks("MyAddIns.xlam").RunAutoMacros xlAutoOpen | | -- | Jim | "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? | | | | | |
| All times are GMT +1. The time now is 07:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com