Run Other non microsoft applications

[Abdul Shakeel]

Hi All,

Could we run other non microsoft applications like Peachtree by the help of
MS excel VBA codes or using macros. I just not want to run the other
application but also perform some other activities on that application could
it possible....

Regards,

Shakeel

 

[Jacob Skaria]

You can use the shell function from VBA to call another application

Dim ProcID As Integer
' Run Calculator.
ProcID = Shell("C:\Windows\system32\calc.exe", AppWinStyle.NormalFocus)

If this post helps click Yes

 

[Nigel]

You can always shell the application to run it, but whether and how you
interact depends on the product you are using.

Myapp = Shell("C:\Sage.exe", 1)

AppActivate Myapp

 

[Abdul Shakeel]

Dear Jacob,

your code works perfectly, but I want to perform some other function as well
after the application is open, as if its already open I gothrough some menu
of this application & run a prosedure to export a report How I could do this

 

[Jacob Skaria]

If you cannot create an object of this application....

Try using the SendKeys function..
http://msdn.microsoft.com/en-us/library/8c6yea83(VS.85).aspx

If this post helps click Yes