How to distribute Macros/write add-ins in Office product

[Neo]

Hello All,

I am doing VB programming for a long time and recently moved to VBA for
Word and Excel. Writing macro is very much like reguler Visual Basic
except, distribution is a big problem. As of now, I am just sending
document everyone. But I don't have any nice way to install Macro,
also, no way to hide the source code.

I believe this can be done through add-ins. How can I write add-ins in
VBA? So that I can distribute it with ease and can be used from any
office file. I would like to know tools used for this purpose. I read
something abot Office Developer, but I am still not sure, if it's new
tool or just part of regular Visual Studio. Any information/links would
be very helpful.

Thanks,
Pravin A. Sable

 

[Norman Jones]

Hi Pravin,

See Jan Karel Pieterse's tutorial at:

http://www.jkp-ads.com/Articles/DistributeMacro00.htm

 

[Bob Phillips]

Writing add-ins

http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[John.Greenan]

Hi,

Why not use a COM Add-in? You can still write code in VB, rather than VBA.

Have a look at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoffpro01/html/COMAdd-insPartI.asp

and

http://msdn.microsoft.com/library/d...re/html/dewlkwalkthroughcreatingcomadd-in.asp

 

[Neo]

because, MS Office is very common software to get in any company, even
if it's not software oriented, but not Visual Studio. Getting
everything done with VBA is very big plus.