Distributing excel macros

[scottpat]

Pretty simple question. If we develop an excel macro, how do we distribute and install that macro to the users’ personal.xls? We have an internal web page a file could be downloaded from.

These are non technical users. Downloading from a web page and answering a few install prompts will work. Cut/paste vba code is not going to work.

Companies must do this all the time. How?

Thanks,

Scott

 

[fredericofonseca]

You need to do it as an add-in, and place it on the users's ADDINS directory. (C:\Documents and Settings\(username)\Application Data\Microsoft\AddIns)

And in order for the users not to do anything you will also need to add a registry entry to automatically open that Add-in.
This is on xxxx\software\microsoft\office\(version)\excel\options
and is a string with a name of "OPENx" and with a value equal to the name of the add-in (e.g. myaddin.xls)

where xxx can be
"HKEY_current_user"
or/and
"HKEY_USERS\(very long string of active configuration"

I normally create one or more add-ins and and put then on their folder and add the entries to the registry automaticaly when they login.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com