Controlling other softwares using vba

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

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

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