whilburn presented the following explanation :
Thanks Garry :)


My VBA knowledge in this area is rudimentary. I was under the
impression that the object references were more of an API shell that
made the application objects for Project available to Excel. I
suppose theres no work around. The person works remotely and its not
that they cant purchase Project, its that the computer is managed by a
group who will not allow un-certified software to run on their system.

Thanks again.

Project is included in one of the higher level editions of MS Office,
or it can be purchased as a MSO Addon to standard editions of MS
Office. If your group has installed the higher edition that includes
Project then chances are it will be present on their computers.
Otherwise, there's no workaround.

Did you explore if any of the newer versions of Excel offer anything
that allows import from Project? Also, I believe Project allows export
to Excel.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc