Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-16-2017, 04:29 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,
I couldn't wait until tomorrow to try it, so I tried it early this morning. It works.
But I have a long way to go to understand subroutines. To make it work, I had to take out these three lines:

Undo 1 'Put the spaces back in the text.
lbl_Exit:
Exit Sub

My good book doesn't mention Undo but various places in the internet show it. I am sure I can get that to work later after a little more studying. For right now, it doesn't matter if the spaces are taken out of my original document.

I am an old COBOL programmer and I have already made some pretty advanced use of nested if statements in my MACROS. And I know about subroutines in COBOL, but I still have to learn how to do it in VBA.

By the way, I am pasting to another document in another application that is not Microsoft Office. I build a document, item by item, with about 29 other similar Macros. And it is really important to take the spaces out. It is a real load off of my time if I can depend on the Macro to do it before I paste it.

Thanks Greg, I am going to paste this routine in my other Macros tomorrow morning.
Reply With Quote
Reply

Thread Tools
Display Modes


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 06:43 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