Of course of course. You really don't have an Oleobject, you have a text
file that you want to extract certain strings. I have done this a lot. It
could get complicated depending on the file. If you post some of the text
file and specify what string you need extracted I wil get yyou started, maybe
even get the whole thing done depending on how complex the task is.

"SteveDB1" wrote:

Hi all.
I have need to pull text data from an embedded, or an OLE object I pull
from-- in this case-- an AutoCAD DWG file.
Thus far I've been going through the embedded element one line-item at a
time, and have finally gotten tired of it.
Is there a way to pull the information off of an embedded object within
excel?
I'm using Office2007.
Thank you.