VBA

#1
Hey

I sure this may have been asked before but what do you recommend LISP VBA??? I want to learn one these so which do you think is the best and where can io learn quickly??

Thanks

#2
cwp,

Yes your are right - the question is asked by all new CAD programmers.

VBA is FAST (compiled into machine language), has a Graphical User Interface (GUI)built in, has a Development Environment (IDE) built in and can be secured.

LISP is slower, the GUI is another language with differing syntax - Dialog Control Language (DCL), has no Development Environment other than an ASCII editor or you can purchase an IDE and is not secure unless you use an encrypted after developing your code.

Lisp is easy to learn because you can type the code at the command line and Lisp returns the result.

VBA is easy to learn after you understand Object Orientated Programming (OOP) and MS Office products use VBA such as Excel and Word. These have recording abilities similar to the ICAD Script recording and you can see the code after a record. Once you understand VBA in ICAD, it is easy to automate Excel or Word to produce your reports or create or read Access databases.

Try my tutorial on this forum – Getting Started in VBA


------------------
Regards
John Finlay
Don't want to post a question - email me direct on john@acecad.com.au

#4
cwp,

VBA is a licensed Microsoft Product and must be purchased. It is integrated in the Professional Version of IntelliCAD.

With VBA you can easily develop your own applications that look and feel like Windows applications. This is called Rapid Application Development (RAD) where the user interface is created visually and you use event driven objects located in a special class module called a Form, that offers the user selections or provides information.

I purchased an IDE for Lisp that was more expensive than the IntelliCAD Professional Version – I don’t receive any benefits for my comments I just personally feel it is good value.


------------------
Regards
John Finlay
Don't want to post a question - email me direct on john@acecad.com.au

#5
this is going to show you how much I know about VBA and alike but there is visual basic with microsoft excel can I use this for VBA programming???

#6
cwp,

Yes you can use VBA in Excel, Word and any other program with VBA to program IntelliCAD.

In Excel you can even startup or shutdown IntelliCAD and draw in the background.

That's the benefit of learning VBA.



------------------
Regards
John Finlay
Don't want to post a question - email me direct on john@acecad.com.au

#7
Hey thanks for replys.. I have been starting to goin through your tutorials and am finding that i can't understand all the jargon that u use . I have no real programming experience apart from Marco's. Is there a book that I can get like VBA for dummies ???

#8
CWP,

There are many books available for VBA in Excel (Excel 97 Programming for Windows for Dummies by John Walkenbach) and none that I know of for VBA in ICAD.

For novice programmers there are benefits using Excel because it has a record facility.

I could do a very basic program to get you started because I also had trouble with the jargon when transferring from Lisp to VBA.

Are you trying VBA in Excel or VBA in ICAD?


------------------
Regards
John Finlay
Don't want to post a question - email me direct on john@acecad.com.au

#10
cwp,

VBA in Word is also OK.

Do you want to know how to launch IntelliCAD from Word and draw some lines?

Do you want to expose IntelliCAD's Objects and be able to have access to these from Word?

You can have good fun driving programs from other programs. Using Word you can type text and have the text inserted in IntelliCAD.


------------------
Regards
John Finlay
Don't want to post a question - email me direct on john@acecad.com.au

#11
Hey..

You have me thinking now.. I wasn't aware that you could do those sort of things.

This is what I do I'm a Mechanical Services detail draftsperson. I work in the commercial/industrial & Mining Industry.. HVAC if you have heard of it.

I have two main projects that I want to get done first up.

a: For each ductwork connection I have to produce a flange drilling detail fully dimensioned to suit ductwork sizes. The parameters include: I.D & O.D, ISO Standard Flanges to suit each range of duct size etc.. etc

b: I have to produce a ductwork detail for each piece of ductwork and want to input the sizes, lenghts, materials, flanges, I.D etc etc..

I want to be able to do these from a dialog box similar to the door insertion routine.

Do you think these sort of things will be able to be achieved??
cron