How to copy to clipboard using Access/VBA?

by

VB 6 provides a Clipboard object that makes all of this extremely simple and convenient, but unfortunately that’s not available from VBA.

If it were me, I’d go the API route. There’s no reason to be scared of calling native APIs; the language provides you with the ability to do that for a reason.

However, a simpler alternative is to use the DataObject class, which is part of the Forms library. I would only recommend going this route if you are already using functionality from the Forms library in your app. Adding a reference to this library only to use the clipboard seems a bit silly.

For example, to place some text on the clipboard, you could use the following code:

Dim clipboard As MSForms.DataObject
Set clipboard = New MSForms.DataObject
clipboard.SetText "A string value"
clipboard.PutInClipboard

Or, to copy text from the clipboard into a string variable:

Dim clipboard As MSForms.DataObject
Dim strContents As String

Set clipboard = New MSForms.DataObject
clipboard.GetFromClipboard
strContents = clipboard.GetText

More Related Contents:

  1. How can you get the clipboard contents with a Windows command?
  2. Access clipboard in Windows batch file
  3. How can I execute a shell command using VBA?
  4. VBA:IE-How to assign pathname to file input tag without popup file upload form?
  5. What encoding/code page is cmd.exe using?
  6. What characters are forbidden in Windows and Linux directory names?
  7. Setting up a cron job in Windows
  8. Windows Batch Variables Won’t Set
  9. Set Windows process (or user) memory limit
  10. How to code a BAT file to always run as admin mode?
  11. WIX Installer with modern look and feel
  12. How do I get Docker to run on a Windows system behind a corporate firewall?
  13. Change case of a file on Windows? [duplicate]
  14. How to stop a program compiled with MinGW (g++) from opening a console window in windows
  15. Moving default AVD configuration folder (.android)
  16. How to change the default browser used by jupyter notebook in windows
  17. Power off an USB device in software on Windows
  18. Create Named Pipe C++ Windows
  19. Printing PDFs from Windows Command Line
  20. Automatic rescaling of an application on high-dpi Windows platform?
  21. Volume binding using docker compose on Windows
  22. Tutorial for installing numpy with OpenBLAS on Windows
  23. The R console is in my native language, how can I set R to English?
  24. WMI “installed” query different from add/remove programs list?
  25. How to disable Hyper-V in command line?
  26. What precisely does ‘Run as administrator’ do? [closed]
  27. Use FFmpeg in Visual Studio
  28. How do you strip quotes out of an ECHO’ed string in a Windows batch file?
  29. Why isn’t UTF-8 allowed as the “ANSI” code page?
  30. windows cmd: problems with for /f with a quoted command with quoted parameters

Leave a Comment