topic Re: Compiling VBA in VBA Forum

Compiling VBA

Anonymous — Wed, 03 May 2000 13:08:26 GMT

Is there any way to compile a vba program so that other people cannot modify
it?

Re: Compiling VBA

Anonymous — Wed, 03 May 2000 13:35:21 GMT

JR,

Technically you can not 'compile' it, but you can assign a password that
will prevent you code from being viewed and/or changed.

In the VBA Editor in AutoCAD 2000, select [Tools/ACADProject Properties...]
then select the [Protection] tab.

Until later,

Jeremy McMahan
Premier Product Support
WW Support & Services, Autodesk
Discussion Q&A: http://www.autodesk.com/discussion

"JR" wrote in message
news:ef04b10.-1@WebX.SaUCah8kaAW...
> Is there any way to compile a vba program so that other people cannot
modify
> it?
>

Re: Compiling VBA

Anonymous — Wed, 03 May 2000 13:46:39 GMT

If you buy Visual Basic ver 6 and use it instead of VBA or Access. Then you can "Compile" it to Create a .EXE file.
This is what a lot of people are doing (Uing VB5 0r 6)
I use both VB6 and Access '97 depending on need.
The Code usually pastes from one to the other.
In either you need to click tools References and Check "AutoCAD 2000 Type Library" and VB or Access will recognize the AutoCAD commands.
AutoCAD must be installed on the machine yor are programming on.

Re: Compiling VBA

Anonymous — Wed, 03 May 2000 14:42:31 GMT

JR,
If your just worried about user damage, then you can set a password under
the project properties. But as far as compiling, no. If someone really wants to
get past your password, they will. But your average acad user will be prevented
from accessing your code. If you prefer to compile, then you'll need to create
an ocx or dll in VB.
-Josh

JR wrote:

> Is there any way to compile a vba program so that other people cannot modify
> it?

Re:

Anonymous — Wed, 03 May 2000 15:38:31 GMT

Can you give a steo by step explanation of creating *.exe's.

Thanks in advance.