Hi Guys,

I'm new to this forum but I have intermediate knowledge of VBA.


I have a form that I would like to fill-out from excel. I get the data already in xls and I have to retype everything into this form. It's only once a month but it's a worst day of the month for me. I call this the opposite of work smart.

It's a none MS application which inputs data into networked dB. Because it's at work I can't just import data into it (limited access, won't be allowed) nor I can get our IT staff to create an import function. Also, the form checks the data and creates some reference numbers.

I was thinking if I can get excel to type or paste the data from the cells to the fields on the form and then tab on the form as it moves to the next cell. I know it sounds like going back to stone ages with the technology we have right now but this is the only way for me.

What are your thoughts guys. I would greatly appreciate if you can point me to the right direction.

Many thanks,
Dmitri

Dmitri,

If its a non-MS app then I'm guessing that it doesn't expose an object model to allow you to automate it? Casting that option aside the only sensible suggestion I can come up with is to use SendKeys to imitate key presses and the manual input of data. You're right this is stone age technology and is prone to not working but it sounds like the best you can do.

Maccas