to get you started........... i saved a word document w/RTF
formatting, then turned on macro recorder in excel & ran it while i
opened the document, copied it & pasted it. the recorded DID NOT
capture opening the word document or copying the data in word - you'll
have to search the newsgroup for info on how to do that (i've seen it
recently).
but when i pasted it it did record

ActiveSheet.PasteSpecial Format:="Microsoft Word Document Object",
Link:= _
False, DisplayAsIcon:=False

so, like i said, this might get you started. it pasted it as an
embedded object, the formula bar reads =EMBED("Word.Document.8","")
hth
susan


On Feb 1, 11:32 am, wrote:
I have a rtf file which i need to automatically import using a macro
in excel. But i am lost in finding a solution to this.

I would like to open Excel and run the macro this would open the rtf
in word and cut the information and paste it into excel.

is this possible ?

Thanks

Dan