VBA-API form filler for external application
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.