Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Copy Gantt chart to clipboard

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 22-10-2009
Member
 
Join Date: Oct 2004
Posts: 21
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.

Reply With Quote
  #2  
Old 22-10-2009
Member
 
Join Date: Jul 2004
Posts: 128
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:

Quote:
Selection.InlineShapes.AddPicture FileName:= _"C:\Documents and Settings\Jan De Messemaeker\My Documents\My
Pictures\20080511\Afb001.jpg" _, LinkToFile:=False, SaveWithDocument:=True
Reply With Quote
  #3  
Old 23-10-2009
Member
 
Join Date: Sep 2004
Posts: 129
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.
Reply With Quote
  #4  
Old 20-04-2010
Member
 
Join Date: Oct 2009
Posts: 4
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?
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 06:34 AM.