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
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
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
Thanks
RE: VBA enabled applications
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
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: VBA enabled applications
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/