×
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

Communicate with .exe via VBA

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?

RE: Communicate with .exe via VBA

(OP)
Thanks IRstuff. I'll check out OLE. I must confess, this is the first I've heard of it.

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

Quote (LRJ)

Can all engineering software be controlled via command line functions?

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

(OP)
Most software manuals do not contain command line codes for their software - they prefer the user to use the interface which they spend a long time creating.

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.

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