Copy Gantt chart to clipboard

[SoftwareTester]

I want to copy the "View | Gantt chart" to clipboard and paste it into Word
and/or Excel using VBA. How do i do that.

Generating a Giffile just doesn't provide good quality (BTW how do I create
and copy that into Word using VBA?)

 

[Jan De Messemaeker]

Hi,

For me, on all the computers I tried that on, the gif file is perfect. At
one time I've even mistaken it for the real thing.

As for Word, where do I start?
Can you open the Word application?
Once you have the Word application object, can you open the file or create a
new one?

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

Hope his helps,


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[SoftwareTester]

Ok, if you say the GIFfile will be OK I must accept it. But I loaded it into
a viewer (Irfanview) and it didn't show up that clear.

Regarding my ability to open files and so : don't worry, my programming
skils are enough although I'e not programming in MS Project nor Word before
(but using VBA with Excel)

I prefer to copy a picture to the clipboard and pasting it into Word instead
of writing it to file first. But i don't know how to do it using VBA in MS
Project.

I also don't know (yet) how to initiate WHAT view I want to output to a file
and paste into Word. For sure I want the "View | Gantt Chart" but "View |
Tracking Gantt" and a Gantt Chart for each Resource I want to have as well.

Any help will be appreciated.

 

[Michael.Tarnowski]

Ok, if you say the GIFfile will be OK I must accept it. But I loaded it into
a viewer (Irfanview) and it didn't show up that clear.

Regarding my ability to open files and so : don't worry, my programming
skils are enough although I'e not programming in MS Project nor Word before
(but using VBA with Excel)

I prefer to copy a picture to the clipboard and pasting it into Word instead
of writing it to file first. But i don't know how to do it using VBA in MS
Project.

I also don't know (yet) how to initiate WHAT view I want to output to a file
and paste into Word. For sure I want the "View | Gantt Chart"  but "View |
Tracking Gantt" and a Gantt Chart for each Resource I want to have as well.

Any help will be appreciated.

Hi SoftwareTester

pressing the PRINT-key creates a bitmap of the complete screen which
you edit / crop with a regular graphic editor.
HTH cheers Michael

 

[Rob Schneider]

View the GIF with another viewer, e.g. Internet Explorer or other web
browser, and see if it displays better. I've never ever had a problem
with the GIF file not meeting or exceeding my expectations.

--rms

www.rmschneider.com

 

[Jan De Messemaeker]

Hi,

Look up the EditCopyPicture method; with the parmaeter forprinter:=pjscreen
you copy the picture to the clipboard.
Then use selection.paste in Word.
Hope this helps,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf