Project to Excel

[King Kong]

Dear all,

I have a customer who simply resists MS-Project documents.
He even doesn't read them. He is Excel only.
So now, if I want to give an overview of the deadlines and schedule
I need to "draw" things in excel (like so many other people).
This costs time and just simply sucks.
Now: Is there a way (an ad-in etc.) to export the schedule in a
graphical form to excel?
Thanks
Kay

 

[John]

Dear all,

I have a customer who simply resists MS-Project documents.
He even doesn't read them. He is Excel only.
So now, if I want to give an overview of the deadlines and schedule
I need to "draw" things in excel (like so many other people).
This costs time and just simply sucks.
Now: Is there a way (an ad-in etc.) to export the schedule in a
graphical form to excel?
Thanks
Kay

Kay,
As far as I know there is no such add-in although a VBA macro could be
developed to effectively do exactly what you need. However, let me ask a
question. Is the client more interested in the tabular data (i.e. Task
Names, Dates, etc.) or in the graphical presentation? If a graphical
presentation is more important, you could use the Copy Picture function
to take a snapshot of the Gantt Chart view. Either use the Copy Picture
icon (the little camera) or go to Edit/Copy Picture and paste the view
into a graphic friendly application such as PowerPoint. If however, the
client is really more interested in the tabular data, you can export
static (non-timescaled) data to Excel using an export map. Go to
File/Save As and select "Microsoft Excel Workbook" in the "Save as type"
selection box at the bottom of the Save window. When you hit "Save" you
will get an export mapping window where you can use an existing map or
create your own. For more information, see "Exporting" in the help file.
Or, as I said previously, if the client wants both tabular data and the
graphic data but only in Excel, a VBA macro can do that. It would be a
LOT easier than drawing manually.

Hope this helps.
John

 

[Kay Schulz]

Hi

Kay,
As far as I know there is no such add-in although a VBA macro could be
developed to effectively do exactly what you need. However, let me ask a
question. Is the client more interested in the tabular data (i.e. Task
Names, Dates, etc.) or in the graphical presentation? If a graphical
presentation is more important, you could use the Copy Picture function

Colors and bars and graphics.

to take a snapshot of the Gantt Chart view. Either use the Copy Picture

But this is not the cas. It does not like excel

:-(
Kay

 

[John]

Hi


Colors and bars and graphics.



But this is not the cas. It does not like excel

:-(
Kay

Kay,
I don't think you really answered the question (i.e. tabular data or
graphics or both). However it sounds like your client has a real thing
for Excel. If that is the case, a VBA macro is the only way to go (or
spend a lot of time drawing manually).

John

 

[Steve House [MVP]]

Copy Picture can save the file as a jpg file. Then you can insert it into
Excel as a graphic object just like you insert clipart. With a photo editor
you could even get rid of any reference to it having come from MSP before
posting it into Excel if your client is that opposed to MS Project.

 

[Mike Glen]

Hi Kay ,

Welcome to this Microsoft Project newsgroup

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