Function or Subprocedure

[zaska]

I am just confused in developing a macro.

I have to run an application named sqt

i have assiagned this as Q = CreateObject("sqt.application")

This sqt application runs a process called analysis.

T = Q.Analysis

So...how do i run this application using VB...

Thanks

 

[zaska]

Kindly suggest me with the syntax part for running a third party application using VBA

Thanks

 

[Ruddles]

You could Shell to it but then you wouldn't be able to communicate with it very well, as far as I'm aware... data in, perhaps, but data out, no, unless perhaps you could get it to write its output to a disk file.

If this other application is DDE-compliant you could open a DDE connection to it but you'd need to find out which commands were available across that type of connection. I've connected from Excel to Word and to Access via DDE but I've never even tried with any non-MS applications. I'm aware others have done this though.

http://en.wikipedia.org/wiki/Dynamic_Data_Exchange


Perhaps you could:-

• Google dde and your application's name to find out whether it's DDE-compliant and whether anyone else has done this before
• ask the application's vendor directly whether their product is DDE-compliant
• Google dde msdn for some generic code

If you're lucky the vendors will be able to supply you with a list of the implemented commands and if you're very lucky, maybe some sample code as well.