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

Hi Pravin,

See Jan Karel Pieterse's tutorial at:

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


---
Regards,
Norman

"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

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

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

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.