I believe there are examples in either of these files. The xl97 version is
in the old windows help file format. The xl2000 one is in the Internet
Explorer based help format used by office 2000 and later:

http://support.microsoft.com/?id=167223
OFF97: Microsoft Office 97 Automation Help File Available (Q167223)

http://support.microsoft.com/?id=260410
OFF2000: Microsoft Office 2000 Automation Help File Available (Q260410)

In any event, they do show you how to use Automation to control another
application (that supports COM), such as MS Project.

--
Regards,
Tom Ogilvy

"zouzou" wrote in message
om...
hi all ,
i need help to create a macro on excel which extract information from
Ms project files , someone can give me some information or code of
macro ....


thanks in advance

zouzou