How does one read one line of text from Windows Clipboard in VBA?
How does one read one line of text from Windows Clipboard in VBA?
Just asked my friend google that exact question and got a lot of results but not sure which will help you.
But what I might do is past all the data into a unbound field then grab the first line from that.
In retrospect, my OP thread title question is a bit misleading given the problem has more to do with using the clipboard to asynchronously communicate between Access apps.
I have a DB with a message-board that supports communication between apps that I can augment to solve the problem. I just thought there might be a common VBA functionality that I'd not yet come across. Terry Kreft wrote some VBA code several years ago that I've used for ages to put text on the clipboard and it can also be used to "get" data off the clipboard. I could use that in a pinch but it doesn't have anything that addresses synchronization between apps open at the same time. Using the message-board approach just involves a bit of waiting for app to app response but at least not vulnerable to unintended user actions involving the clipboard but unrelated to the apps.
Bill
Can't the apps talk to each other are we talking two ms programs ?
Two totally independent Access DBs running asynchronously. One wanting services normally provided by the 2nd. It's a little different if the 1st app Shells to the 2nd app, in which case the 2nd app would be dedicated to the requests of the 1st app. It's all manageable, just a question of what the independent apps happen to be involved with at any given time. With my message-board approach, the servicing app simply needs to periodically check the board to see if there's a command on the command stack that requires its services.