Does anyone have suggestions how to automate the following;
I have a list containing several hundred names; ABC, DEF, GHI, etc.
My VBA loops throught this NameList, - one by one, until the list is empty, and for each loop, the VBA shall exit Excel { thru a shell command..? } and enter into a third-party application, to copy some information from this application into the Windows Clipboard. (Manually this works...).
This is done if the following keysequence is peformed while I am into the third-party program;
"ABC[Enter][ctrl-A][Ctrl-C]"
Of couse Excel must change ABC to DEF for the second round, etc.
So, for each round my program will have new data in clipboard, that the rest of my VBA puts in an appropriate place. This works..
But my problem is how to handle the key command line, while outside the Excel VBA.
Anyone have suggsetions on how to do this..?
Bookmarks