Should I learn VBA?

Should I learn VBA?

Anonymous
Not applicable
604 Views
11 Replies
Message 1 of 12

Should I learn VBA?

Anonymous
Not applicable
Hi guys....

I hate to admit this but I know NOTHING abt VBA.....
and very very little abt LISP.

However.... I am curious.... is VBA hard to learn and
should I spend some time learning it over LISP?

If I learn VBA for use with Mec Desktop..... can I also
apply that knowledge to MS Access, Excel, etc?
0 Likes
605 Views
11 Replies
Replies (11)
Message 2 of 12

Anonymous
Not applicable
wrote in message
news:dvumjtgbe09vcfg3srv8aidg79vu8snrro@4ax.com...

> If I learn VBA for use with Mec Desktop..... can I also
> apply that knowledge to MS Access, Excel, etc?
Yes, the basic language is the same, just the Object Model changes. In other
words, you have a different kit of parts in each application, but the parts
all get connected in basically the same way. Also, if you know VBA, you can
also move to VB Script and stand alone VB apps without much pain.
But, as Chuck says, learn both. While the LISP wont translate to other
applications like the VBA will, there are still things in Acad that are
better done in LISP, so if you really want to develope for AutoCAD, you need
both.

HTH,
Gordon
0 Likes
Message 3 of 12

Anonymous
Not applicable
Learn both. They compliment each other.

Chuck


wrote in message
news:dvumjtgbe09vcfg3srv8aidg79vu8snrro@4ax.com...
> Hi guys....
>
> I hate to admit this but I know NOTHING abt VBA.....
> and very very little abt LISP.
>
> However.... I am curious.... is VBA hard to learn and
> should I spend some time learning it over LISP?
>
> If I learn VBA for use with Mec Desktop..... can I also
> apply that knowledge to MS Access, Excel, etc?
0 Likes
Message 4 of 12

Anonymous
Not applicable
Chuck Gabriel wrote:

> Learn both. They compliment each other.

Or either, but neither will get you nowhere.

Terry
0 Likes
Message 5 of 12

Anonymous
Not applicable
>> Learn both. They compliment each other.
>
>Or either, but neither will get you nowhere.
>
>Terry


OK.... what is best way to learn VBA?

Also.... again.... if learning VBA for Mech Desktop
use.... will it also apply to Acess, Excel, and other
apps?
0 Likes
Message 6 of 12

Anonymous
Not applicable
Get Joe Sutphin's AutoCAD 2000 VBA book -- but i guess he has a new one
coming out in August or so... Great book for VBA.
As far as AutoLISP -- my "Maximizing AutoLISP" book is over 8 years old, and
in about as many pieces -- very well written, but now out of date although
it make for a good reference on the older functions. Not sure of any good
recent AutoLISP book. If you get to Autodesk University, take Lynn Allen's
classes on AutoLISP -- fun classes!
0 Likes
Message 7 of 12

Anonymous
Not applicable
AutoDesk includes a tutorial called "Garden Path". It comes in both Lisp
and VBA versions. Use it! It will give you a pretty quick, hands-on,
step-by-step intro. And, it's free. Then go look at some of the sample
apps included on the CD (also free). Then ask some more questions.
--
John Goodfellow
irtf'nm
use 'microtouch' in address to email

wrote in message
news:6s1njtgbqia431euppbfoc7h0rm31fcngj@4ax.com...
> >> Learn both. They compliment each other.
> >
> >Or either, but neither will get you nowhere.
> >
> >Terry
>
>
> OK.... what is best way to learn VBA?
>
> Also.... again.... if learning VBA for Mech Desktop
> use.... will it also apply to Acess, Excel, and other
> apps?
0 Likes
Message 8 of 12

Anonymous
Not applicable
< Learn both. They *compliment* each other. >

vba: "Hi there Lisp, you sexy devil, I just love your reactors..."
lisp: "Thanks! You have such stylish controls, we should hook up some time!"

...sorry I coudn't resist. it's just one of those afternoons when all
interest in work has been lost.

Cheers,
Jacob Dinardi

Chuck Gabriel wrote in message
news:3CF6A6795974FA0FD8DC34A201EA2CA3@in.WebX.maYIadrTaRb...
Learn both. They compliment each other.

Chuck


wrote in message
news:dvumjtgbe09vcfg3srv8aidg79vu8snrro@4ax.com...
> Hi guys....
>
> I hate to admit this but I know NOTHING abt VBA.....
> and very very little abt LISP.
>
> However.... I am curious.... is VBA hard to learn and
> should I spend some time learning it over LISP?
>
> If I learn VBA for use with Mec Desktop..... can I also
> apply that knowledge to MS Access, Excel, etc?
0 Likes
Message 9 of 12

Anonymous
Not applicable
jmorris@chromerod.com wrote:

> Also.... again.... if learning VBA for Mech Desktop
> use.... will it also apply to Acess, Excel, and other
> apps?

Absolutely. When I jump into Access Basic it feels the same. When I
jump into VB6 for a standalone it feels the same.

If you want maximum control over the drawing database with little
concern for interface, use Vlisp. Otherwise use VBA.

I was writing BASIC when writing BASIC wasn't cool. 🐵

Terry
0 Likes
Message 10 of 12

Anonymous
Not applicable
Should have seen that one coming :^)


"Jacob Dinardi" wrote in message
news:DB320962F2F61C5372144BF618930B3B@in.WebX.maYIadrTaRb...
> < Learn both. They *compliment* each other. >
>
> vba: "Hi there Lisp, you sexy devil, I just love your reactors..."
> lisp: "Thanks! You have such stylish controls, we should hook up some time!"
>
> ...sorry I coudn't resist. it's just one of those afternoons when all
> interest in work has been lost.
>
> Cheers,
> Jacob Dinardi
0 Likes
Message 11 of 12

Anonymous
Not applicable
>AutoDesk includes a tutorial called "Garden Path".


OK..... will check it out.

I was just told that Inventor does not have VBA.....
true?

If yes..... does it have ANY programming language in
it?

Will it EVER have VBA?
0 Likes
Message 12 of 12

Anonymous
Not applicable
The Inventor object model can be accessed from "Full" Visual Basic or C.
I've read and/or heard that VBA was to become available in R2, but still
hasn't made it into R4. There are some sample VB programs that are made
available with the R4 installation. I don't know if they are VB5 or VB6.

Sorry for the earlier private reply. I intended to reply to this thread.

Gary
0 Likes