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

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

If this post helps click Yes
---------------
Jacob Skaria


"Abdul Shakeel" wrote:

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
--
Regards,



"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Abdul Shakeel" wrote:

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