VBA enabled applications

[borja1980]

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

 

[IRstuff]

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

Need help writing a question or understanding a reply? forum1529


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

 

[borja1980]

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

 

[MintJulep]

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.

 

[SkipVought]

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,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[IDS]

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/