| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? | | |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? | | |
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? | | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 files not showing on screen when opened in Excel 2007 | Setting up and Configuration of Excel | |||
| Conflict in excel 2007 with Outlook 2007 attachment excel | Excel Discussion (Misc queries) | |||
| Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
| Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please | Excel Programming | |||
| Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Hybrid Mode
