Communicate with .exe via VBA
Communicate with .exe via VBA
(OP)
I've seen very mixed comments elsewhere regarding the ability to communicate with a .exe file via VBA. It seems that one can use sendkeys (unreliably) to communicate with other Microsoft software (e.g. word), though communicating to engineering software .exe files does not seem possible.
Has anyone been able to develop some code to send commands to a .exe file from VBA? If so, could you share how this communication is done?
Has anyone been able to develop some code to send commands to a .exe file from VBA? If so, could you share how this communication is done?





RE: Communicate with .exe via VBA
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: Communicate with .exe via VBA
https://newtonexcelbach.wordpress.com/2016/06/30/r...
It seems to me that it gives you everything you need to know to do what you want to do, but if it doesn't, please let me know what is lacking, or what doesn't work.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Communicate with .exe via VBA
Thanks also, Doug. That's a great starting point for me.
Can all engineering software be controlled via command line functions? How does one determine what those functions are? I expect them to vary depending on the software, but if there is a way to figure it out that would be great.
RE: Communicate with .exe via VBA
I'm not sure the person exists who can answer this question. "All" engineering software? To answer this, one would need to know all engineering software. Quite the undertaking!
All engineering software that can be controlled via command line functions can be controlled by command line functions. However, the only way to know if your software can be controlled by command line functions is to check the documentation... help files... sometimes the "/?" switch or something. I don't know of any way to know the allowable command line arguments of any given .exe file.
What is your objective with this question? General knowledge, or do you have a specific application you're needing to get working?
-handleman, CSWP (The new, easy test)
RE: Communicate with .exe via VBA
Of course there is, you READ THE MANUAL.
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: Communicate with .exe via VBA
I was wondering whether there was a general way to find out whether command line functions work, e.g. a standard input to try in the command line which most software would use (similar to F1 generally being help for most software on MS operating systems). I guess the best thing to do is contact the software developer.
RE: Communicate with .exe via VBA
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm