×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

VBA enabled applications

VBA enabled applications

VBA enabled applications

(OP)
Hi. I am an engineer interested in VBA. In the past, I have worked with the VBA language, and i have written little applications with it in Excel, Autocad, Access and SAP2000. Given the fact that there are a lot of software that can be automated with VBA, i was wondering is someone knew where i could find a list of the VBA-enabled applications, I mean, applications that can be accesed with VBA. In the VBA developer environment, there are a lot of references, but I think only the ones referring to the software that has been set up in my computer.
It seesm to me that there are also certain applications that can operate with VBA, but have not a manual describing the objects model, and the procedures, variables objects, and so forth. It would be good to be able to use these elements, and i would like to know if there is a way to access all this elements. I dont know if it is posible to search the *dll files of an VBA enabled application, i order to investigate how to use this elements.
Thanks in advence

RE: VBA enabled applications

VBA is typically not a standalone application, and is usually customized for its specific target application, so Excel VBA and Word VBA are not 100% compatible. Running VBA commands for one application from another can be done, but it will be slow and cumbersome.

TTFN
FAQ731-376: Eng-Tips.com Forum Policies
[IMG http://tinyurl.com/7ofakss]
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers


Of course I can. I can do anything. I can do absolutely anything. I'm an expert!
There is a homework forum hosted by engineering.com: http://www.engineering.com/AskForum/aff/32.aspx

RE: VBA enabled applications

(OP)
Hi. I can agree with you that VBA is not the fastest language in the world, but it allows the develepor to work with most of the functinality of compatible applications. That way, i can perform a lot of calculations without the need to be in front of the computer. For example, an engineer can work with the sap2000, an structural software, with the user interface, but that is very slow, or can also work with VBA. I would like to ask you if you can recommend me another way to access the funcionality of a certain software. I use vba because I know that with it, most of the object model of Excel, for example, can be worked with.
Thanks

RE: VBA enabled applications

You might want to ask this question on Tek-Tips. http://www.tek-tips.com/threadminder.cfm?pid=707

As sister site more focused on computers and programming. Someone there might have an idea where to find your answer.

This being the internet, expect someone to chastise you for cross-posting if you do.

RE: VBA enabled applications

Borja, I'd also recommend checking out Tek-Tips, a sister site of Eng-Tips. There are lots of programmer types. I have an engineering degree, but have majored a bit in Excel VBA interfaces with an assortment of databases. Give it a try.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: VBA enabled applications

I don't know of any list of VBA enabled applications, and it does seem that there is a move away from VBA. Intellicad (open source AutoCAD clone) for instance no longer supports it (I believe).

In the engineering context the only one that I know of (other than those you mentioned) with extensive VBA support is the FEA package Strand7, but I'm sure there are many others.

Even Microsoft play down the abilities of VBA these days, although I imagine they will continue to support it.

It seems to me that the best option is to focus on using VBA in one of the MS Office applications (and Excel is the obvious choice for engineers), and use the available facilities for linking to other languages where required.

For instance I have recently been working with linking to Python, which also allows easy to use connection to C++ and Fortran, which should cover just about anything.

Search my blog link below for Python for some examples.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources