How to add or run Add-in file

[sdsurzh]

Hi,


I have created a macro and saved it as 2007 Add-in file now. how i will add that add-in the activeworkbook or how i will run that particular macro.


Thanks,

Suresh Kumar S

 

[Hui]

Suresh


It depends on what/how you have written the addin?


To add the file in, goto

File, options, Addins

Manage Addin's, Go

Use the Browse button and find your addin

Apply


If you wrote a Function you should now be able to use it in any file by simply =myFunction(x, y, z) or however you coded it


If it has Subroutines, they can be called from another module using:

Call mySubroutine(x,y,z)

 

[sdsurzh]

Thanks Hui.