Using excel data and creating a timeline in vision using vba

[chamdan]

Help is needed,

From a worksheet in Excel extract data from column "C" (Start date) and column "D" (Finish Date) and generate a timeline in vision using vba macro.
Has anyone done it? if yes, please provide me with a sample as I am a newbie in vba.

Excel and Visio version 2007
Regards,

Chuck

[Yacine]

Unless I misunderstood your request, this is one of the most basic functions of visio. Did you google it?

[chamdan]

Thanks Yacine for your prompt reply, I will google it and see if there is something similar.

Regards,

[aledlund]

your challenge is going to be the fact that timeline's are produced with a Visio add-in, not native code. your code is going to have to interact with the existing program (which calls visio).

this might be helpful
http://visguy.com/vgforum/index.php?topic=1160.msg4999

al