If it says Copied to the clipboard, how do I retrieve the object that was copied to the clipboard on Windows 7?

If it says Copied to the clipboard, how do I retrieve the object that was copied to the clipboard on Windows 7?
LVL 1
hermesalphaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hello ThereSystem AdministratorCommented:
I am not sure what you wanna achieve but there are many Clipboard Managers and miniprograms that will tell you that you have copied something into clipboard.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Joe Winograd, Fellow&MVEDeveloperCommented:
In most programs, it's Edit>Paste or Ctrl-V.
0
Helen FeddemaCommented:
In case this is useful, here is some code for working with the Clipboard in VBA.  The code gets data from the Clipboard and pastes it into a Word document:

   Dim strMessage As String
   Dim intResult As Integer
   Dim dat As MSForms.DataObject
   Dim strCode As String
   
   strMessage = "Import code from clipboard?"
   intResult = MsgBox(strMessage, vbOKCancel, "Question")
   
   If intResult = vbCancel Then
      GoTo ErrorHandlerExit
   End If
   
   Set dat = New MSForms.DataObject
   dat.GetFromClipboard
   strCode = dat.GetText
   Application.Selection.TypeText strCode
   Application.Selection.HomeKey Unit:=wdStory

Open in new window

You will need a reference to the MS Forms object library to use this code.
0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Helen FeddemaCommented:
RE Joe Winograd's comment -- in Office 2016, a recent bug disabled Copy and Paste, so the keyboard shortcuts may not work (depending on which Office version you are running, and which updates you have installed).
0
Joe Winograd, Fellow&MVEDeveloperCommented:
That's interesting, Helen, although I haven't seen that problem here. I'm running the latest desktop Office 2016 (via an Office 365 subscription) and there are no problems with copy/paste — both the ribbon icons and the keyboard shortcuts work fine. I don't recollect any recent (or not recent, for that matter) Office version where copy/paste didn't work, and I use that pretty much every day. That's a whale of a bug for Office! :)  Thanks for sharing. Regards, Joe
0
Helen FeddemaCommented:
I think it must have been fixed quickly -- I experienced it while working on a client's database, and he also experienced it on his system.  It seems to have cleared up for now, though you never know -- the obnoxious Object Model Guardian pop-up that interferes with VBA code working with Outlook has come and gone over versions and updates.
0
Joe Winograd, Fellow&MVEDeveloperCommented:
Yes, I'm sure it was fixed very quickly — a copy/paste bug in Office would attract a boatload of attention!
0
Joe Winograd, Fellow&MVEDeveloperCommented:
The question is, "how do I retrieve the object that was copied to the clipboard on Windows 7?" The experts provided three ways to do that: (1) use a Clipboard Manager; (2) do Edit>Paste or Ctrl-V; (3) use VBA code that works with the clipboard. All three answers are valid, and without any feedback from the asker on any of the comments, it's impossible to go further. There's no "Best Solution", so I'm marking the first post as the Accepted Solution and the other two as Assisted Solutions, but splitting the points evenly among the three experts.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows OS

From novice to tech pro — start learning today.