VBA executable file

Hi,
I'm having a VBA program which I want to load on other systems. I dont want my code to be visible nor I dont want to give the password. I want to know how to compile a VBA program.

Thanks

 

You can't compile a vba program into an executable. For that you'll need
full vb.

Kevin

want my code to be visible nor I dont want to give the password. I want to
know how to compile a VBA program.

 

Thanks for the reply.
Can you please tell me how to convert dvb file into VB exe file. Will this exe work same as dvb file ?

 

You need to make a call to the Application and to the Drawing unlike VBA
which is native to AutoCAD..

Dim acadApp As AcadApplication
Set acadApp = GetObject _
(, "AutoCAD.Application.15")
If Err Then
Err.Clear
Set acadApp = CreateObject _
("AutoCAD.Application.15")
If Err Then
MsgBox Err.Description
Exit Sub
End If
End If

' Connect to the AutoCAD drawing
Dim ThisDrawing As AcadDocument
Set ThisDrawing = acadApp.ActiveDocument

'Now code like you would in VBA...ie
With ThisDrawing.
'''''Rip it up..
End With

'then complile to .exe...
gl..
Paul

exe work same as dvb file ?

 

Hi,

You have to buy VB.
Clip boards the code across. Read the help files to get information on the
small changes you need to make.
Check you code runs.
Compile it.

--


Laurie Comerford
CADApps
www.cadapps.com.au

exe work same as dvb file ?

 

If your intention is to be able to distribute your AutoCAD VBA routines in
compiled mode, there is more to it than just passing the code to VB.
I'm sure you won't want to run your code out of AutoCAD's process space,
'cause it's going to crawl.

You'll need to create a VB Activex DLL, which besides involving a little
more complex translation work, you'll also have to deal with the
installation issues.

--
Saludos, Ing. Jorge Jimenez, SICAD S.A., Costa Rica

exe work same as dvb file ?

 

Jorge, Does this mean it faster to call a dll from vba code than to run an
executable?
Thank You
Paul

 

I woud say VBA is faster as it is running in process from a VB exe it has to
run cross process.
Also using with an exe if you have more than one Acad session running you
cannot control which one your exe uses

 

Yes

 

Thanks for the reply.
I want to call Architectural Desktop from VB. How to know the version which is installed in the users system and how to call Architectural Desktop. Can u please help me.

 

Hi,
I want to create a dll and run it from VBA. Can u please help me how to translate the code to VB to create a dll.
Thanks in advance.

 

ACADVER....at the command line...

which is installed in the users system and how to call Architectural
Desktop. Can u please help me.