Export Project Plan from PWA to image or excel

[Coolpran]

I am using Project Server 2003, Project Professional 2003 and Project
Web Access.
I have a project plan with many different graphical indicators on the
Gantt chart view.
I also have custom views with similar graphical indicators.


Let's say I'm viewing a plan from Project Web Access and I have
selected a particular view (which contains graphical indicators).
When I export to excel, it exports the graphical indicators as numeric
values rather than pictures.


My question is -
Can I export a selected view, from PWA, to either Excel or as an image
file, which will retain the graphics?


I know that using Project Professional, I can do it in a round-about
way, by clicking the camera tool first, and then saving as web page.

 

[drumdoc]

We ran into the same issue. The solution we used was to build a custom
VBA Macro in Excel to chance the cells back to graphics. You will need
someone with development skills if you go this route. Good luck.

 

[Coolpran]

Hi drumdoc,

thanks for the response.

do you have an example code which I can use?
I can give that to my team and ask them to build on that.

I know that there is a EditCopyPicture() method in MSPrjGrid object.

can I use modify the PWA page to include a button which calls the
EditCopyPicture method and push back the generated image?

 

[Coolpran]

Hi drumdoc.... could you please send me an example code of your solution.

thanks
Coolpran

 

[drumdoc]

Sorry - I took so long to reply. I will try to run it down.