I have seen similar threads but not found an answer (assume I got something wrong)
I use the very simple example below:
When I run the code I see the contents of the active cell are now in the variable S2 - i.e. seems to be in the clipboard
Please Login or Register to view this content.
After execution there doesn't appear to be anything in the Clipboard. I get 2 small rectangles when I do a ctrl v and there is nothing to PASTE in the Clipboard section of the HOME tab.
Any help appreciated
That didn't happen to me. The program put the value in the clipboard and I could paste it anywhere, although successive pastes would erase previous pastes
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
It's a bug in the dataobject in Windows8 or later. It happens if you have any File Explorer windows open while running the code. It's safer to use Windows API calls to access the clipboard. A search of this (or other) forum will find many threads on this topic.
Rory
Yes, what took a few lines now take a whole lot more.
I found this was helpful
https://www.thespreadsheetguru.com/b...-the-clipboard
Just be aware that the code in that link is not correct, and will likely not work on 64bit Office.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks