"Jerry" wrote in message
...
I have written several functions in VBA and wish to move them to C++. To
increase the speed. I also want to use it to help protect much of the code
from prying eyes. What I would like to know is how the two types compare
in
speed, the complexity of building function and anything that would be a
benefit over the other.

I have Visual Studio .Net Developer edition with Office XP.

Another question I have is if I were to do a xll addin How do you do it in
.Net. All articles Ive seen show it being done in visual studio 6.0 in xp
they have no wizard to get it started.

If your add-ins have already been written, it's easier to make a
COM/Automation add-in. Both are *much* faster than VBA.


Here's a link where you can find out more about xll's
http://www.whooper.co.uk/excelstuff.htm#tip2

This link is also of interest
http://www.managedxll.net/excel/net/xll/en/index.html

/Fredrik