VBA or VBA.net

VBA or VBA.net

Anonymous
Not applicable
634 Views
5 Replies
Message 1 of 6

VBA or VBA.net

Anonymous
Not applicable
Should I be learning vba 6 or vb.net 2005...Is autodesk's vb editor going to go to the new vb.net?
0 Likes
635 Views
5 Replies
Replies (5)
Message 2 of 6

GTVic
Advisor
Advisor
Regarding VBA inside AutoCAD:

Note: Autodesk does not have a VB editor, they have a VBA editor - VB and VBA are not very compatible.

I don't know that Microsoft plans on switching from VBA to "VBA .NET". Right now there is no such thing. Potentially it would break many user developed macros in Excel, Word etc. so VBA might be around for a long time.

Regarding Autodesk's other programming interface... I believe Autodesk is in the process of switching from ObjectARX to .NET. That allows you to use C# or VB in the Visual Studio .NET environment.
0 Likes
Message 3 of 6

Anonymous
Not applicable
I would say both..
VBA is embeded in many programs
including Office and AutoCAD
and it's going to stay a while longer.

And since can you use the .NET Framework Class Library
from VB and I believe from VBA also
it is a good idea to get to know the framework.

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

wrote in message news:[email protected]...
Should I be learning vba 6 or vb.net 2005...Is autodesk's vb editor going to
go to the new vb.net?
0 Likes
Message 4 of 6

Anonymous
Not applicable
Thanks for clearing that up for me

Patster
0 Likes
Message 5 of 6

Anonymous
Not applicable
Jorge,
"it's going to stay a while longer."

So correct. Within the last month I recieved the VBA 6.4 SDK to enable me to evaluate the benefits of integrating VBA into our applications.

Have you looked at how VBA 6.3 is changing? If you have a chance take a look at the CreateObject method and other enhancements.

CreateObject now lets you specify a machine name as an optional argument, which allows developers to create objects on remote machines using DCOM. This now allows for creating distributed, n-tier applications much easier by a machine. A component's location is now a simple function argument. This is a strong benefit to DCOM cross machine boundaries complications.

Another benefit is modeless userforms: User Forms, the custom dialog box designer that ships with VBA, now supports modeless dialog boxes. Developers can now create dialog boxes that can be displayed and used simultaneously as the host application.

Hope this extends the wall of aptitude for this topic.

Regards,

Bob Coward
0 Likes
Message 6 of 6

Anonymous
Not applicable
Oh yes, and COM will stay more than a while longer.!
That's why the .net framework was made with the interop capability.

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


wrote in message news:[email protected]...
Jorge,
"it's going to stay a while longer."

So correct. Within the last month I recieved the VBA 6.4 SDK to enable me
to evaluate the benefits of integrating VBA into our applications.

Have you looked at how VBA 6.3 is changing? If you have a chance take a
look at the CreateObject method and other enhancements.

CreateObject now lets you specify a machine name as an optional argument,
which allows developers to create objects on remote machines using DCOM.
This now allows for creating distributed, n-tier applications much easier by
a machine. A component's location is now a simple function argument. This
is a strong benefit to DCOM cross machine boundaries complications.

Another benefit is modeless userforms: User Forms, the custom dialog box
designer that ships with VBA, now supports modeless dialog boxes.
Developers can now create dialog boxes that can be displayed and used
simultaneously as the host application.

Hope this extends the wall of aptitude for this topic.

Regards,

Bob Coward
0 Likes