I would like to read data from an open word document into an excel spread
sheet. I think the way to access the document is to use the getobject
method. I don't want users to have to enter the path name I just want to
have the word document open and read from there.

According to the help files for GetObject([pathname] [, class]) If the
pathname argument is omitted, GetObject returns a currently active object of
the specified type. The class has the format appname.objecttype

I have tried set myobject = getobject(,"word.documents") but get an 429
error message "Activex component can't create object".

Can some one help me here do I have the right syntax? do I have the correct
class syntax( I have tried other guesses without success).

Thanks in advance

Paul