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
How to use VBA to read text entered in an editBox on a custom Ribbon tab?

I have added a tab to the Ribbon in MS Project 2010 using the SetCustomUI VBA method as detailed here: http://msdn.microsoft.com/en-us/library/ee767705. The tab XML loads fine and the layout is set up properly. The problem …

Read More