View Single Post
 
Old 08-28-2015, 01:15 AM
hanvyj hanvyj is offline Windows XP Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting

I'm generating a word doc from a requirements list, and the cells in the description can have quite a lot of text, and it's often formatted with bold or italic within the cell, so only certain words are bold.

Requirement.Description is the Range:

Quote:
Requirement.Description.Select
Selection.Copy
wrdApp.Selection.Paste
This pastes the formatting fine, but even though the range is a single cell, it inserts it into the word document in a table (of a single cell). Unlike the user interface, which just pastes the text.

I also can't use Requirement.Description.Value as that will strip out all the formatting and I'd just get the text.

Does anyone know a way of transferring it over, or copying it with it without having it paste as a table?

Cheers
Reply With Quote