How do I export a Gantt Chart from MS Project to MS Word using VBA

vba ms-project gantt-chart
user191093 picture user191093 · Oct 21, 2009 · Viewed 40.2k times · Source

Using MS Project 2003 i want to export the "View | Gantt Chart" to MS Word (2000) using VBA. How can I achieve this?

Answer

Web Based Project Management picture Web Based Project Management · Mar 9, 2010

In Project, Use Edit, Copy Picture. there's a camera icon on the standard toolbar (the top one) ... you can take a "photo" of your gantt chart and use that in word Version 2003 also has a Wizard for this export HTH I always select the task rows and then when using the "camera" select the option of selected tasks.

Related questions

VBA array sort function?

I'm looking for a decent sort implementation for arrays in VBA. A Quicksort would be preferred. Or any other sort algorithm other than bubble or merge would suffice. Please note that this is to work with MS Project 2003, so should …

Read More
Slow VBA macro writing in cells

I have a VBA macro, that writes in data into a cleared out worksheet, but it's really slow! I'm instantiating Excel from a Project Professional. Set xlApp = New Excel.Application xlApp.ScreenUpdating = False Dim NewBook As Excel.WorkBook Dim ws …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More