I need to enter data in a Windows app (COBOL based). The app is designed such that tabbing is required to move from field to field for data entry in each field. I'd like to generate the data for the app from Excel, using VBA to send it to the clipboard. I can script the VBA such that both the data elements and some sort of tab key indicator are present, but what I can't figure out is how to get ME to interpret the tab key designator and write it to a macro, along with the data, and then play that macro into the COBOL app.
For example, I can create this line: {#key BACKSPACE#}{#key BACKSPACE#}{#key TAB#}72422346833{#key TAB#}WAW22080013{#key TAB#}{#key TAB#}{#key TAB#}{#key TAB#}1{#key TAB#}{#key TAB#}.
In the sample above, the keystroke indicators are from a different app, but hopefully self-explanatory.
With the above on the clipboard, I'd like to use a hot key, have ME import/process the data to convert the keystroke instruction to something ME understands, then replay the string of data with the proper keystrokes instead of literally typing out {#key , etc.
Can anyone provide at least some initial guidance? I can easily figure out how to send the clipboard data to keystrokes, but not with the special keys being used.
Edit: as an alternative to using the clipboard, I could use VBA to send the data to a text file, Excel file, or .csv file, but would still need to process it so ME could send the correct keystrokes.