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?
 
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
 
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.