Trying to get ADDIN tool to work

[sonny.thind]

I got this code to install an addin from the internet however I cannot get it to work ,not sure what I am doing wrong.

This is the code in the addin macro in my worksheet which is saved as an addin . My actual macro sheet is attached
what am I doing wrong?

Please Login or Register  to view this content.

[royUK]

That code adds a Commandbar. It's not really suitable for Excel 2010 but you will find the commandbar in the addins tab.

It will only run when the addin is installed, your example is not an addin

[sonny.thind]

Hi

I have actually installed the addin created with this macro which is tool.xla in the normal addins folder and the .However I keep getting an error

[royUK]

What error? It should be .xlam for Excel 2007

[sonny.thind]

I am getting the basic error "cannot run the macro file" . but Can I use this excel file as .xla itself (see attached)

[royUK]

I'm not sure what you have done. I don't think the buttons actually run any code.

[sonny.thind]

SO how do I convert this worksheet into a new addin ?.Is there a better tutorial somewhere?

[royUK]

here's probably the best one

[royUK]

here's probably the best one

Your actual code could do with tidying up as well.

[sonny.thind]

For Sure this absolutely helps! this is an awesome site.

Wow! I actually figured it out now. Thanks again!!