Can macro/procedure be stored externally?

[hon]

Just want to find out if it is possible to store a macro/procedure externally(globally) so that any excel work book can run it.

 

[acw]

Hi

IT can be stored as an addin, or in the personal.xls workbook. Both of these will allow any book to run them. Another alternative would be to create a DLL.....


Tony

 

[hon]

Hi Tony

Could you please give me some examples on how to achieve it? I would like to be able to maintain just one global macro so that any changes to it are immediately available to all workbooks referencing it.

thanks
Hon

 

[Nimrod]

Deploy your Excel macros from a central file

http://www.personal-computer-tutor.com/personalxls.htm
http://office.microsoft.com/en-us/assistance/HA010872961033.aspx

 

[hon]

Tony, it is good stuff. I am almost there. I just want to know if it is possible to have that personal.xls stored on the network so that I don't have to copy it to everyone's PC.

 

[hon]

Another question. I created a macro and stored it in personal.xls. But how do I reference it in another workbook?

 

[acw]

Hi

I don't think you can use the personal.xls for general consumption. YOu will have to use an addin (not too sure about this). If you have the addin on a network, then each user will have to enable it in the tools, addins. To reference things from a macro, go tools, references and bring in the addin. It can then be a normal call.


Tony

 

[hon]

Hi Tony

Forget about the network issues. Is it still possible to call the macro stored in the personal.xls from the active workwork?

Thanks
Hon

 

[pcc]

yuo can call a macro from another file like this

Application.Run ("personal.xls!macroname")

 

[hon]

Thanks. It works.