Sir,

I am using excel 2003

I would like to get word bookmarked data into excel cell.

for this i used the formula

=Word.Document.8|'C:\\My Documents\\hai.doc'!'!OLE_LINK1'

where C:\\My Documents\\hai.doc is my word file
OLE_LINK1 is my book mark name.

It is working good for single line bookmarks.

If i enter multiple lines in that bookmarks it only gets the single.

what can i do.. ??

Please help me..