Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-15-2017, 10:11 AM
StephenRay StephenRay is offline Error with Clipboard - Getting Spaces Out of Clipboard Windows 7 64bit Error with Clipboard - Getting Spaces Out of Clipboard Office 2010 64bit
Advanced Beginner
Error with Clipboard - Getting Spaces Out of Clipboard
 
Join Date: Jan 2012
Location: Overland Park, Kansas
Posts: 53
StephenRay is on a distinguished road
Default

Greg, Thanks for your reply. Good idea! I didn't know it was possible. I will try it on Monday at work. In the mean time, I will have to study what you wrote with a good book, "Mastering VBA for Microsoft Office 2016" by Richard Mansfield.
But I get the idea, I think. You made what was highlighted/selected - a variable, oRng. Then you trim it. Then you copy it into the clipboard. Finally you put any spaces back into the highlighted text on the document.
But I don't see any use for the first statement:
Dim oClipboard As DataObject
Is it necessary?
Thank you so much!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Clipboard error Win10 Pro 64 bkcell Windows 1 03-24-2018 04:20 AM
clipboard error freezes workbook bkcell Excel 4 06-18-2017 08:00 PM
Do you want to keep your clipboard? Cam-Bean Word 0 06-14-2017 02:55 AM
Getting the clipboard value: Dataobject error arjfca Word VBA 0 12-04-2014 01:51 AM
Error with Clipboard - Getting Spaces Out of Clipboard Get clipboard Image janith Word 2 05-27-2012 07:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft