Visio 2007 Calendar appoinments - why is shape sheet value showing a decimal for a date?
Visio 2007 Calendar appoinments - why is shape sheet value showing a decimal for a date?
(OP)
Hello!
Two questions regarding Visio 2007 shape sheet date and time formats
I was given a task of writing a Visio VBA script that will take a Monthly Calendar shape that
has many appointment shapes within, extract the appointment info, and send an Outlook email
to various people containing message populated with the appointment shape data.
I am confused as to the difference between what I see in the little Shape Data window and
what I see in the Shape sheet. Example: With a calendar appointment shape, the shape data
displays the start time, end time, and date exactly how I would like. The Shape sheet shows
me some odd decimal values of which I have no clue as to what they mean.
My questions are:
1. When trying to extract appointment shape start, end, and day values, do I try to code
in using Cells, CellsSRC, or something else?
2. Can you provide a hint as to how to extract shape data for an email message?
I have attached a PDF picture hopefully clarifying my delimma.
I believe if I can get past this hurdle I should be able to handle the rest of the task.
Thank you
Tom
Two questions regarding Visio 2007 shape sheet date and time formats
I was given a task of writing a Visio VBA script that will take a Monthly Calendar shape that
has many appointment shapes within, extract the appointment info, and send an Outlook email
to various people containing message populated with the appointment shape data.
I am confused as to the difference between what I see in the little Shape Data window and
what I see in the Shape sheet. Example: With a calendar appointment shape, the shape data
displays the start time, end time, and date exactly how I would like. The Shape sheet shows
me some odd decimal values of which I have no clue as to what they mean.
My questions are:
1. When trying to extract appointment shape start, end, and day values, do I try to code
in using Cells, CellsSRC, or something else?
2. Can you provide a hint as to how to extract shape data for an email message?
I have attached a PDF picture hopefully clarifying my delimma.
I believe if I can get past this hurdle I should be able to handle the rest of the task.
Thank you
Tom





RE: Visio 2007 Calendar appoinments - why is shape sheet value showing a decimal for a date?
I suggest that you post in Tek-Tips.com, which is more oriented to this type of question.
TTFN
I can do absolutely anything. I'm an expert!
homework forum: //www.engineering.com/AskForum/aff/32.aspx
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers
RE: Visio 2007 Calendar appoinments - why is shape sheet value showing a decimal for a date?
Thanks for the assistance.
I'm considering having manager start learning how to use MS Outlook for scheduling meetings
rather than starting from Visio ending into Outlook. Seems like a backwards task.
Thanks!
RE: Visio 2007 Calendar appoinments - why is shape sheet value showing a decimal for a date?
TTFN
I can do absolutely anything. I'm an expert!
homework forum: //www.engineering.com/AskForum/aff/32.aspx
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers