RTF data from excel into word

[hamzajosh]

I need to export RTF data with multiple fonts and subscripts, superscripts from excel into word selectively ( meaning field by field) If i use DAO, i lose the formatting. The manual method is copy in excel and paste in word. I need to do it using VBA

 

[lespaul]

Not real sure, but have you tried PasteSpecial? Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned

 

[hamzajosh]

The excel selection.copy and word selection.paste work fine, but it becomes manual work doing it one by one. I need to do it from one place i.e excel copy and word paste from one macro ( FROM ANYWHERE EITHER EXCEL OR WORD).