Controlling other softwares using vba

[alexonias]

hi,
I don't know anything about vb or vba. I have an application which is not Wordpad but like wordpad which works on the windows platform. it contains different menus out of which the file menu has a "deposit" option. when i click on that "deposit" option, a dialog box will appear where we have to type a numerical value and a nonnumerical data.
Now my question is whether i can write program in vba which displays a form in which when i type a numerical and nonnumerical value, automatically opens this application and selects the "deposit"option under file menu and inserts the numerical and nonnumerical values in the appropriate boxes.
I have said that the input numerical & non numerical value is typed in by the user to a form. But now i want these values to be taken from the second and third column of the second row in an excel worksheet. is that possible?

Thankyou,
alex

[BrianB]

We have to imitate inputting text using the keyboard.
Look in VB Editoe Help under Shell and SendKeys for examples.

[RobDog888]

I have seen this thread in a few forums and was wondering if the
sendkeys solution worked for you? There are a few other things
you could do using FindWindow, FindWindowEx, and
SendMessage APIs is the SendKeys solution does not. Try a
search on them or look at the API FAQ in the API forum.

HTH