macro to read from Project
 

Excel doesn't know how to read a binary Microsoft Project file. If there
is an option to export the data to CSV, then Excel could probably read that
(although it would just be data - no particular significance in terms of
managing a project).

--
Regards,
Tom Ogilvy


Kim wrote in message
...
How do I program an Excel macro to open and read from a
Microsoft Project file? I get a 'file format is not
valid' error message.

macro to read from Project
 

What is CSV? A data transfer only would possibly work.

-----Original Message-----
Excel doesn't know how to read a binary Microsoft Project
file. If there
is an option to export the data to CSV, then Excel could
probably read that
(although it would just be data - no particular
significance in terms of
managing a project).

--
Regards,
Tom Ogilvy


Kim wrote in message
...
How do I program an Excel macro to open and read from a
Microsoft Project file? I get a 'file format is not
valid' error message.


.

macro to read from Project
 

Excel doesn't know how to read a binary Microsoft Project file.

there is no command that will open a Microsoft Project file.

--
Regards,
Tom Ogilvy

Kim wrote in message
...
I can do a paste special from Project to XL but am still
unclear about the Visual Basic line needed to actually
open the Project file. A 'WorkbooksOpen' does not work.
Any suggestions?

-----Original Message-----
CSV is a comma separated file

item1,1123,"this, is text",456
item2,3234,"more, text",444

--
Regards,
Tom Ogilvy

Kim wrote in message
...
What is CSV? A data transfer only would possibly work.

-----Original Message-----
Excel doesn't know how to read a binary Microsoft
Project
file. If there
is an option to export the data to CSV, then Excel
could
probably read that
(although it would just be data - no particular
significance in terms of
managing a project).

--
Regards,
Tom Ogilvy


Kim wrote in message
...
How do I program an Excel macro to open and read
from a
Microsoft Project file? I get a 'file format is not
valid' error message.


.



.