How to Clear Office Clipboard with VBA

Saw this on another post, and I have tested it with Word VBA.

'Clearing the Office Clipboard

    Dim oData   As New DataObject 'object to use the clipboard

    oData.SetText text:=Empty 'Clear
    oData.PutInClipboard 'take in the clipboard to empty it

Just copy and paste into your code where ever you need to clear the Clipboard.

Another thing I noticed is that when I .Quit a program, say Excel, it keeps asking me if I want to keep the data is the Clipboard. A work around is to clear the clipboard using the above stated code. See below:

'Clearing the Office Clipboard

    Dim oData   As New DataObject 'object to use the clipboard

    oData.SetText text:=Empty 'Clear
    oData.PutInClipboard 'take in the clipboard to empty it


'You can also just remove the Alert Messages from the Excel Program while    
'the code is running
'Remove alert Messages from the Excel Program when closing
ExcelProgram.DisplayAlerts = False   

'Quiting the Excel Application
ExcelProgram.Quit

I used the above example in a VBA code to import data from an Excel File. See here

Related Posts:

  1. Excel VBA Macro: User Defined Type Not Defined
  2. How do you display code snippets in MS Word preserving format and syntax highlighting?
  3. What does <> mean?
  4. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  5. How to find a value in an excel column by vba code Cells.Find
  6. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  7. Object Required Error in excel VBA
  8. Check if a string contains another string
  9. VBScript to open a dialog to select a filepath
  10. What is a correct MIME type for .docx, .pptx, etc.?
  11. Does VBA have Dictionary Structure?
  12. What are .NumberFormat Options In Excel VBA?
  13. Better way to find last used row
  14. VBA, if a string contains a certain letter
  15. “Sub or Function not defined” when trying to run a VBA script in Outlook
  16. lists and arrays in VBA
  17. Create PDF file using PHP
  18. What is the function of FormulaR1C1?
  19. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  20. What exactly is the function of Application.CutCopyMode property in Excel
  21. Select method of Range class failed via VBA
  22. Does VBA contain a comment block syntax?
  23. VBA Excel – Insert row below with same format including borders and frames
  24. Why does “Paste Method of Worksheet class failed” occasionally occur?
  25. Deleting a file in VBA
  26. How to return a result from a VBA function
  27. How to clear memory to prevent “out of memory error” in excel vba?
  28. Use VBA to Clear Immediate Window?
  29. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  30. VBA: Else without If Error
  31. Recommended IDE for VBA
  32. ByRef argument type mismatch in Excel VBA
  33. How to comment and uncomment blocks of code in the Office VBA Editor
  34. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  35. VBA: Convert Text to Number
  36. VBA Error: “Compile error: Expected End Sub”
  37. Scraping data from website using vba
  38. MS-DOS Batch file pause with enter key
  39. Pass arguments to Constructor in VBA
  40. Error: “Could Not Find Installable ISAM”
  41. Loop without Do error
  42. Row count where data exists
  43. VBA array sort function?
  44. How to install Date Picker form control in Excel 2016
  45. How to install Date Picker form control in Excel 2016
  46. How to fill color in a cell in VBA?
  47. Test or check if sheet exists
  48. How to detect if user select cancel InputBox VBA Excel
  49. macro run-time error ‘9’: subscript out of range
  50. Refreshing all the pivot tables in my excel workbook with a macro
  51. Why does my VBA code throw an “Invalid outside procedure” error?
  52. VBA: Run time error ’91’?
  53. Compare Dates in VBA
  54. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  55. ‘Cannot find DAO350.dll’ file error VB6
  56. Average in VBA in Excel
  57. Excel Solver Password: what is it and where can it be acquired/bought?
  58. VBA Excel “Compile error: Object Required”
  59. Choosing paper size (NOT DEFAULT sizes) in excel vba
  60. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  61. Paste Special error 1004 PasteSpecial method of Range class failed
  62. Using Excel VBA to run SQL query
  63. VBA: Getting run-time 1004: Method ‘Range’ of object ‘_Worksheet’ failed when using cells
  64. Compile error: Next without For || VBA
  65. Cannot run the macro… the macro may not be available in this workbook
  66. Is there a way to crack the password on an Excel VBA Project?
  67. Converting endnotes to hyperlink for export to WordPress

Leave a Comment