I am working on a little program that enters data, cell-by-cell from an Excel spreadsheet into an Oracle Forms Application. I am using the Sendkeys function to do this. Each time a cell is entered into a field in the oracle Forms Application, it is validated. As long as it is valid, the process works fine. If an error in validation occurs an error box pops up. I cannot detect if this happens from with in the Excel Macro (I'm using VBA) and the cells begin to be pasted into the wrong fields - causing an error each time!!
I have been trying (without success) to identify the handle of the Oracle forms screen and then test this every time a cell is validated - I was hoping to detect if an error message came up because it would have a different handle??? Any ideas on this one would be appreciated.
Many Thanks,
Roger Eigenheer
