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.
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
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?