I have a program developed in VBA which run as addin program i
Microsoft Excel. The only protection here is a password which is no
good enough.

I read in office 2000 developers edition I can change this to Active
DLL file and compile it.

I would be greatful if some one can explain to me how to do it.


Regards

--
Message posted from http://www.ExcelForum.com

"...And the next sign of the Apocalypse will be..."
*****
On Mon, 9 Feb 2004 14:04:36 -0600, daniel
wrote:

I have a program developed in VBA which run as addin program in
Microsoft Excel. The only protection here is a password which is not
good enough.

I read in office 2000 developers edition I can change this to Activex
DLL file and compile it.

I would be greatful if some one can explain to me how to do it.


Regards!

You need a copy of Visual Basic 6 (VB5 would probably work - maybe even
VB4). VBA is a superset of VB, and for the most part, VBA can be dropped
into "regular" VB with very little modification. Unfortunately, VB6 &
earlier are no longer for sale, though you can buy copies on eBay and
similar auction sites. Also, I rather doubt that VB.NET would work (but
I don't know for sure).
--
auric "underscore" "underscore" "at" hotmail "dot" com
*****
Born crying, live complaining, die disappointed.

You can write add-in in VS.NET but MS have not supplied PIAs for Office2000 AFAIK.

--

Auric__ wrote in message . ..
"...And the next sign of the Apocalypse will be..."
*****
On Mon, 9 Feb 2004 14:04:36 -0600, daniel
wrote:

I have a program developed in VBA which run as addin program in
Microsoft Excel. The only protection here is a password which is not
good enough.

I read in office 2000 developers edition I can change this to Activex
DLL file and compile it.

I would be greatful if some one can explain to me how to do it.


Regards!

You need a copy of Visual Basic 6 (VB5 would probably work - maybe even
VB4). VBA is a superset of VB, and for the most part, VBA can be dropped
into "regular" VB with very little modification. Unfortunately, VB6 &
earlier are no longer for sale, though you can buy copies on eBay and
similar auction sites. Also, I rather doubt that VB.NET would work (but
I don't know for sure).