Import data and automaticly generate milestones

[WhiplashInfo.se]

I have a problem concerning import of data which I have stored in both Excel
and Access. The data consists of dates and texts related to each date. A
patient, which in my case suffer from rest status after a quite sever car
crash, thus have over more than 10 years had a bunch of contacts with health
care providers for different reasons as doctor´s certificate, medicine and so
on, which I would like to present in Visio. I have looked at the Timeline
stencil, but can’t figurate how to easily import the data and automaticly
generate milestones in the form.

I have read the guidelines and help pages I have found about these matters,
but still get lost.

In the excel the table consist of Date and Action, where action is text
explaining what the health care contact was about that date.

I use Office 2007 Suite inkl Visio Office 2007

Thanks / Tomas

 

[Al Edlund]

I tried to post a vba example of creating/manipulating a timeline with excel
input, but the system doesn't like the size of the zip file. Send me a real
e-mail address. edlund60014 lives over on yahoo.com.
al

 

[Al Edlund]

handled off-line
al