Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way of copying text to Word from Excel
Hello, I'm having some trouble copying cells from Excel to Word by macro.
Let's say I got two cells in excel, A1 and A3 which I need to copy to Word. A1 is Arial, regular. A3 is Verdana, bold. I need to transfer these to Word and preserve the formatting but paste them as text. I have tried pastespecial wdpastetext. This is otherwise fine but does not copy the formatting. Other options I have tried copy the cells as "true cells" to Word (plain pastespecial, pastespecial wdpasteRTF, pastespecial wdpasteHTML) - I need to transfer it as normal text with formatting. Any suggestions how to do it? Thanks guys, TT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep Word formatting when copying text to Excel | Excel Discussion (Misc queries) | |||
Text spacing uneven when copying charts from EXCEL 2007 to WORD 20 | Charts and Charting in Excel | |||
Copying text to Word doc | Excel Discussion (Misc queries) | |||
Text not copying as text from Word to Excel 2003 | Excel Discussion (Misc queries) | |||
Copying Word text to Excel | Excel Programming |