Link a prject to excel

[Ingrid]

If I cut out all activities in Project and then paste them into Excel as a link I will get a dynamic picture of the project in Excel. However I do not get the complete project if i wish to show it on a day-by-day basis. It works OK if I use a smaller scale. There seems to be a limited width either of what is cut out of project or what can be stuck inte excel. Can I in any way change this limit?

 

[Rod Gill]

HI,

No. I would also be careful because the copy and paste/link technique uses
DDE technology which all too easily corrupts one of the files. It's better
to copy or export the data when you need it.

Export time phased data using the Analyze TimeScaled Data in Excel macro. To
run this:
View, Toolbars, Analysis

Excel 2003 with Project 2002+ has a new possibility:
In Project 2002+ save the project file as a .xml file.
Create a .xsd file to define the format of the spreadsheet and what data
appears.
Open the xml file to get your report.

Search msdn.microsoft.com for details on formatting the xsd file.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

If I cut out all activities in Project and then paste them into Excel as a

link I will get a dynamic picture of the project in Excel. However I do not
get the complete project if i wish to show it on a day-by-day basis. It
works OK if I use a smaller scale. There seems to be a limited width either
of what is cut out of project or what can be stuck inte excel. Can I in any
way change this limit?

 

[Mike Glen]

Hi Ingrid,

Welcome to this Microsoft Project newsgroup

I don't know of limits, but there are other ways - please see FAQ Item: 16.
Project Viewer.

FAQs, companion products and other useful Project information can be seen at
this web address: http://www.mvps.org/project/

Hope this helps - please let us know how you get on

Mike Glen
Project MVP