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/de...d-insPartI.asp

and

http://msdn.microsoft.com/library/de...gcomadd-in.asp


--
www.alignment-systems.com


"Neo" wrote:

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