Results 1 to 4 of 4

Thread: Copy Gantt chart to clipboard

  1. #1
    Join Date
    Oct 2004

    Copy Gantt chart to clipboard

    I have prepared a Gantt Chart in Project 2007. I also have MS Office 2007 installed on my PC. I wanted to copy the gantt Chart and past it in MS Excel or Word using VBA. I tried it by generating a Giffile but it is killing up the quality. Can anyone please tell me which is the better way of copying "View | Gantt chart" to clipboard and then pasting it in Word or Excel? Thanks in advance for help.

  2. #2
    Join Date
    Jul 2004

    Re: Copy Gantt chart to clipboard

    Are you able to open Word and are you able to open file or create new file once you have the Word application object? I think the following word VBA instruction inserts a picture:

    Selection.InlineShapes.AddPicture FileName:= _"C:\Documents and Settings\Jan De Messemaeker\My Documents\My
    Pictures\20080511\Afb001.jpg" _, LinkToFile:=False, SaveWithDocument:=True

  3. #3
    Join Date
    Sep 2004
    As you might be knowing the when we hit Print-Scr key it captures the complete screen in bitmap format which can be edited with regular graphic editor. You can try out Internet Explorer or other web browser for viewing GIF. Look up the EditCopyPicture method; with the parmaeter forprinter:=pjscreen you copy the picture to the clipboard. The copy the selection and paste it in word.

  4. #4
    Join Date
    Oct 2009

    Re: Copy Gantt chart to clipboard

    Did you resolve the quality issue, I am having the same problem and want to display a clearer gantt?

Similar Threads

  1. how to create a gantt chart from a pert chart ?
    By Loeb in forum Microsoft Project
    Replies: 5
    Last Post: 08-07-2011, 10:24 AM
  2. Printing Gantt Chart
    By bsk0387 in forum Microsoft Project
    Replies: 1
    Last Post: 16-02-2011, 12:11 AM
  3. Can I work with Gantt Chart in Windows 7
    By Efigenio in forum Operating Systems
    Replies: 6
    Last Post: 28-04-2010, 07:35 PM
  4. What is the Gantt Chart?
    By Emily123 in forum Windows Software
    Replies: 5
    Last Post: 19-03-2010, 04:59 AM
  5. ms project --Gantt chart based on Actual %
    By sitharaiqbal in forum Windows Software
    Replies: 10
    Last Post: 17-02-2010, 05:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts