Draw a vertical lines or shaded columns programatically in a Gantt?


C

Curmudgeon

In Milestones Professional you can easily draw vertical objects
(lines, boxes), tied to dates, of any form/color/fill on a Gantt
programmatically. Is there a way to do this in Project 2003?
 
Ad

Advertisements

J

Jan De Messemaeker

Hi,

Manually or through VBA? (you posted in the VBA newsgroup)
Manually Insert, Drawing; double-click on the drawing for properties - of
which Size and Position.

VBA: search the Object Browse for all methods containing "drawing"

HTH

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

Curmudgeon

Hi,

Manually or through VBA? (you posted in the VBA newsgroup)
Manually Insert, Drawing; double-click on the drawing for properties - of
which Size and Position.

VBA: search the Object Browse for all methods containing "drawing"

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620





- Show quoted text -
Jan,

The problem with the drawing methods is that they merely present the
corresponding dialog for the user to fill in details (position, size,
color, etc.). I want to set all of these programmatically. I thought
briefly that it might be possible to interact with the Project dialog
through SendKeys, but apparently Project VBA does not support SendKeys.
 
J

Jan De Messemaeker

Hi,

Before I go any further, Project VBA DOES support Sendkeys!!
But sendkeys are incompatible with things suich as remote desktop... they
only work on the keyboard connected to the PC itself.

But Yes, I didn't realize all these methods require intervention so I hope
Sendkeys will bring you teh solution.

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

Manually or through VBA? (you posted in the VBA newsgroup)
Manually Insert, Drawing; double-click on the drawing for properties - of
which Size and Position.

VBA: search the Object Browse for all methods containing "drawing"

HTH

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





- Show quoted text -
Jan,

The problem with the drawing methods is that they merely present the
corresponding dialog for the user to fill in details (position, size,
color, etc.). I want to set all of these programmatically. I thought
briefly that it might be possible to interact with the Project dialog
through SendKeys, but apparently Project VBA does not support SendKeys.
 
R

Rod Gill

The danger with Sendkeys is if the user swaps to another application before
the keyboard buffer has been emptied then the remaining keys get used on the
newly activated program with potentially damaging results.

Gook luck!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
Ad

Advertisements

C

Curmudgeon

Hi,

Before I go any further, Project VBA DOES support Sendkeys!!
But sendkeys are incompatible with things suich as remote desktop... they
only work on the keyboard connected to the PC itself.

But Yes, I didn't realize all these methods require intervention so I hope
Sendkeys will bring you teh solution.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620






Jan,

The problem with the drawing methods is that they merely present the
corresponding dialog for the user to fill in details (position, size,
color, etc.). I want to set all of these programmatically. I thought
briefly that it might be possible to interact with the Project dialog
through SendKeys, but apparently Project VBA does not support SendKeys.- Hide quoted text -

- Show quoted text -
For some reason, searching on SendKeys in Project online help returns
no records, so I assumed that the method is not available. In any
case, I can't seem to find a way to select a drawing object in the
Gantt programmatically in order to interact with it, so this idea
doesn't seem to have much promise. I'm not a big fan of SendKeys
anyway, for the reasons Rod outlines among others.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top