|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
10-14-2006, 11:44 PM
|
|||
|
|||
clilpboard parsing
I have some data in a cell that I need to copy to the clipboard and then paste into another application. The text in the cell is in the format of:
PC COMPUTER-HARDWARE-ACCESSORIES-MOUSE The application that will receive this text has a 256 char field, but is picky enough not to allow ANY spaces before or after the text (it treats the spaces within as part of the text, so the space between PC and Computer is acceptible. I copy the text to the clipboard as a VBA Value: Sub Copy_1() Application.ScreenUpdating = False Range("D3").Interior.ColorIndex = 3 Range("Z103").Select Selection.ClearContents Range("Z103").Value = Range("D3").Value Range("Z103").Copy End Sub However, When I go to paste it into the other Application, clipboard seems to have added a Space and/or Page Eject (Carriage Return)into the data (the cell has no spaces around the text if the cursor positioning is a true indication). Is there a way to load this data into clipboard and paste it to another doc without adding leading or trailing characters or page ejects (hidden or otherwise)? I have found no definition of the Parse option so far, but suspect that that only helps for loading the data into the clipboard. 
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
