Pasting the rich text into the cells manually drops all of the information, nice and neat, right into the cells.
Attempting to paste the rich text with activesheet.paste fails miserably, and leaves me, at best, with only scraps of information.
Attempting to paste the rich text with .pastespecial pastes the rich text as an image.
Is there a method I can use with vba that will mimic normal manual pasting?
Hello DJose,
Unfortunately, VBA won't be much help. RTF is a separate program used to format text using embedded control codes. VBA does not natively include a RTF dll or ocx component. You could add a RTF TextBox control to manipulate the data, but it wouldn't be a straightforward approach to copying and pasting.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks