View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default How to distribute Macros/write add-ins in Office product

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)

"Neo" wrote in message
oups.com...
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