How to import add-in to excel2007?

**maroni** · 08-11-2012, 06:06 PM

Hello
I created a macro and save it as *.xlam, but I can't add it in excel.
In book Excel 2007 Bible is description how to do it, but I'm doing something wrong.

Books description:
1. Create a folder named customUI.
2. Inside of that folder, create a text file named customUI.xml, with the following XML code:

HTML Code:

3. Locate and select your XLAM file in Windows Explorer. This example assumes that the file is
named change case.xlam.
4. Add a .zip extension to the file by pressing F2 and then changing the filename to changecase.
xlam.zip.
5. Drag the customUI folder you created in Step 1 into the change case.xlam.zip file.
(Windows treats ZIP files as if they were folders.) Figure 45.6 shows the contents of the change
case.xlam.zip file.

6. Double-click the rels folder within the ZIP file. This folder contains one file, .rels.
7. Drag the .rels file to a location outside of the ZIP file (your Desktop, for example).
8. Open the .rels file (which is an XML file) with a text editor, such as Notepad.
9. Add the following line to the .rels file, before the </Relationships> tag:
<Relationship Type=”http://schemas.microsoft.com/office/2006/
relationships/ui/extensibility” Target=”/customUI/customUI.xml”/>
10. Drag the .rels file back into the ZIP file, overwriting the original version.
11. Remove the .zip extension so that the file is back to its original name: change case.xlam.

After this is done, just go to options>add-ins and than select my macro.
Than I get an error that file extension is not right.

Can someone help me.
Is there any other less complicated way to do it.
Thanks

**BuckoAk** · 08-11-2012, 06:50 PM

Give this a try.

This may also make your life a little easyer when creating the xml portion for the ribbon, see links
http://www.andypope.info/vba/ribboneditor_2010.htm
or
http://openxmldeveloper.org/blog/b/o...8/07/7293.aspx

There was some weird things going on in the original xml file, I adjusted the santex below out and it works fine.
No more zipping and unzipping with the programs above.

Hope this helps.

HTML Code:

**Andy Pope** · 08-12-2012, 05:51 AM

@ BuckoAk,

Note the namespace in your xml is for xl2010 and the code needs to go in CustomUI14 folder.

xmlns="http://schemas.microsoft.com/office/2009/07/customui">

Can you post the file you created?

**BuckoAk** · 08-12-2012, 07:01 AM

Andy,

I used open xml developer to check and adjust the xml info. I just dropped the xml info into a new file but did not save it.
I've copied and pasted xml santex between excel files without any issues using the developer.

Please explain why a file is needed.

**Andy Pope** · 08-12-2012, 07:03 AM

Sorry, I was asking the OP for their file, as the instruction appear sensible and should work.

**maroni** · 08-12-2012, 08:26 AM

Thanks guys for your help, but I'm not expert in excel programming.
I downloaded ribboneditor and I have no clue how to import my macro to ribbon.
I would appriciate if you could do explination for dummies.
Thnaks

**Andy Pope** · 08-13-2012, 03:30 AM

Have a read of Ron de Bruin's ribbon articles.
http://www.rondebruin.nl/ribbon.htm

If you are still stuck post back and include your workbook, as previously suggested.

**maroni** · 08-13-2012, 02:16 PM

Thanks for the link.
This was easy, but now I can run the macro only from this workbook.
I want to run this macro from every woorkbook, so that I don't need to open this workbook with macro.
I attached the file, if you are so kind to help me.
Thanks

**BuckoAk** · 08-13-2012, 03:37 PM

You can turn your file into an Add-In.
Do a save-as and use the file extension .xlam
Next go to Files > Options > Add-ins > Go (bottom of dialog) > Make sure your add-in has a Check mark next to it.
Now every time you load excel your macros will be available for your use.

**maroni** · 08-14-2012, 12:50 PM

Thanks
Now I have what I wanted

**Cutter** · 08-14-2012, 03:59 PM

@ maroni

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

**codeck** · 08-19-2012, 09:49 AM

Nice post,
by the way, I customize the ribbon, and some group with more buttons, how do i link the button to a worksheet ?

**maroni** · 08-19-2012, 02:55 PM

Check the above post from Andy Pope. It's a link to instruction.
Do it like examlpe and save it as add-in.

How to import add-in to excel2007?

LinkBack

Thread Tools

Rate This Thread

Display

How to import add-in to excel2007?

Re: How to import add-in to excel2007?

Re: How to import add-in to excel2007?

Re: How to import add-in to excel2007?

Re: How to import add-in to excel2007?

Re: How to import add-in to excel2007?

Re: How to import add-in to excel2007?

Re: How to import add-in to excel2007?

Re: How to import add-in to excel2007?

Re: How to import add-in to excel2007?

Re: How to import add-in to excel2007?

Re: How to import add-in to excel2007?

Re: How to import add-in to excel2007?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions