My purpose is to provide a tool for someone to be able to view data
that was contained and managed from within a Project file. That person
does not have Project. They have Excel. My code references for the
Project file is based on the selection of the Project object reference
in VB editor.
My code, that i wrote/borrowed, works successfully on my machine, but
it isnt working on the machine for which it was intended. The
computers are set up the same, with exception to mine having Microsoft
Project.

Thanks.

After serious thinking whilburn wrote :
My purpose is to provide a tool for someone to be able to view data
that was contained and managed from within a Project file. That person
does not have Project. They have Excel. My code references for the
Project file is based on the selection of the Project object reference
in VB editor.
My code, that i wrote/borrowed, works successfully on my machine, but
it isnt working on the machine for which it was intended. The
computers are set up the same, with exception to mine having Microsoft
Project.

Thanks.

All object refs must be properly installed and registered on the target
machine. What you're asking is pretty much no different than sending
someone without Excel installed an Excel file to look at.

As to whether or not Excel can import MS Project files directly, I
don't think so <AFAIK.

--
Garry

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

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.

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