A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Retrieving work week (start/end times) from outlook with VBA



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 20th 09, 05:25 PM posted to microsoft.public.outlook.program_vba
ker_01[_2_]
external usenet poster
 
Posts: 21
Default Retrieving work week (start/end times) from outlook with VBA

I've searched (object browser, help file, google), but no joy.

I'm pulling certain appointments (based on the contents of the subject line)
and I need to differentiate between any partial or full appointments that are
within the user's workday, and partial or full appointments that are outside
that user's workday (for the partials, I'll have to calculate the number of
hours that are actually within the workday). Different users have different
start and end times set on their calendar.

I haven't been able to find the part of the object model to show the
individual user's workday- can anyone point me in the right directions? Once
I have that I can calculate backwards to get the duration within the workday,
unless there is an easier way to do this somehow.

Thanks!
Keith


Ads
  #2  
Old May 21st 09, 03:44 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Retrieving work week (start/end times) from outlook with VBA

Those settings are stored in the registry, at
HKCU\Software\Microsoft\Office\11.0\Outlook\Option s\Calendar (11.0 is for
Outlook 2003, for Outlook 2007 it's 12.0, etc.).

The values are stored as DWORD's, you will have to reverse engineer what the
meanings are, I'm not sure how they are interpreted by Outlook. Make changes
in the Outlook settings and see which registry values change and in what way
depending on the settings you change.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"ker_01" wrote in message
...
I've searched (object browser, help file, google), but no joy.

I'm pulling certain appointments (based on the contents of the subject
line)
and I need to differentiate between any partial or full appointments that
are
within the user's workday, and partial or full appointments that are
outside
that user's workday (for the partials, I'll have to calculate the number
of
hours that are actually within the workday). Different users have
different
start and end times set on their calendar.

I haven't been able to find the part of the object model to show the
individual user's workday- can anyone point me in the right directions?
Once
I have that I can calculate backwards to get the duration within the
workday,
unless there is an easier way to do this somehow.

Thanks!
Keith



  #3  
Old May 21st 09, 05:19 PM posted to microsoft.public.outlook.program_vba
ker_01[_2_]
external usenet poster
 
Posts: 21
Default Retrieving work week (start/end times) from outlook with VBA

I think that kills my project.

I have code that pulls any appointment which includes "vacation" in the
title, and uses that to build a department vacation calendar. The problem is
that some folks use recurring appointments (monday, but recur 3 times) or
long appointments (start Mon 7am, ends Thurs 3pm). Right now I'm trying to
set it up so that a person with shared viewing permissions can run the
program for our whole department, so we don't have to bug each person to run
the code on their PC. In my example, the Thurs 3pm could mean 8 hours of
vacation if their worksday ends at 3pm, or it could mean 6 hours vacation, if
their workday ends at 5pm. Eventually we'll have people in another time
zone, and that will make it even tougher to figure out.

I'm surprised, because I would have thought that it would be useful
information to have available to others who are scheduling appointments. If
I'm scheduling an appointment with someone on the other coast of the US, or
someone in Europe, it sure would be nice to see their workday (other times
greyed out as unavailable) so that I could be respectful of their schedule.
Maybe that will be in Office2010...

Thank you,
Keith

"Ken Slovak - [MVP - Outlook]" wrote:

Those settings are stored in the registry, at
HKCU\Software\Microsoft\Office\11.0\Outlook\Option s\Calendar (11.0 is for
Outlook 2003, for Outlook 2007 it's 12.0, etc.).

The values are stored as DWORD's, you will have to reverse engineer what the
meanings are, I'm not sure how they are interpreted by Outlook. Make changes
in the Outlook settings and see which registry values change and in what way
depending on the settings you change.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"ker_01" wrote in message
...
I've searched (object browser, help file, google), but no joy.

I'm pulling certain appointments (based on the contents of the subject
line)
and I need to differentiate between any partial or full appointments that
are
within the user's workday, and partial or full appointments that are
outside
that user's workday (for the partials, I'll have to calculate the number
of
hours that are actually within the workday). Different users have
different
start and end times set on their calendar.

I haven't been able to find the part of the object model to show the
individual user's workday- can anyone point me in the right directions?
Once
I have that I can calculate backwards to get the duration within the
workday,
unless there is an easier way to do this somehow.

Thanks!
Keith




  #4  
Old May 21st 09, 08:51 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Retrieving work week (start/end times) from outlook with VBA

I don't think it will be in Outlook 2010.

I really don't see the problem. All it takes is a number of changes to the
work week settings, saved from Outlook, with checking the registry each time
to begin to see what patterns there are for the relevant settings. A
registry monitor set to filter on changes to only that registry key will let
you observe the results of every change. Then you would know what the
settings are, what they mean and how to work with them. Maybe a half day's
work at most.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"ker_01" wrote in message
...
I think that kills my project.

I have code that pulls any appointment which includes "vacation" in the
title, and uses that to build a department vacation calendar. The problem
is
that some folks use recurring appointments (monday, but recur 3 times) or
long appointments (start Mon 7am, ends Thurs 3pm). Right now I'm trying to
set it up so that a person with shared viewing permissions can run the
program for our whole department, so we don't have to bug each person to
run
the code on their PC. In my example, the Thurs 3pm could mean 8 hours of
vacation if their worksday ends at 3pm, or it could mean 6 hours vacation,
if
their workday ends at 5pm. Eventually we'll have people in another time
zone, and that will make it even tougher to figure out.

I'm surprised, because I would have thought that it would be useful
information to have available to others who are scheduling appointments.
If
I'm scheduling an appointment with someone on the other coast of the US,
or
someone in Europe, it sure would be nice to see their workday (other times
greyed out as unavailable) so that I could be respectful of their
schedule.
Maybe that will be in Office2010...

Thank you,
Keith


  #5  
Old May 22nd 09, 07:56 PM posted to microsoft.public.outlook.program_vba
ker_01[_2_]
external usenet poster
 
Posts: 21
Default Retrieving work week (start/end times) from outlook with VBA

I'm flattered by your estimation of my programming skills ;-)

I'd be willing to learn how the registry setting works- the roadblock I was
referring to is that we wanted to set this up so that one person (who had
view-only permissions to everyone's calendar) could update the data from
everyone's calendars from the one PC. If the workday settings are on each
individual PC/Registry, then that one 'administrator' won't have access to
them.

I think the intermediate solution would be to have each person document
their work hours manually in my output Excel file, and have the code check
each vacation appointment against the work hours for that employee. Then the
one adminstrator can pull the actual calendar contents from there out.

Best,
Keith

"Ken Slovak - [MVP - Outlook]" wrote:

I don't think it will be in Outlook 2010.

I really don't see the problem. All it takes is a number of changes to the
work week settings, saved from Outlook, with checking the registry each time
to begin to see what patterns there are for the relevant settings. A
registry monitor set to filter on changes to only that registry key will let
you observe the results of every change. Then you would know what the
settings are, what they mean and how to work with them. Maybe a half day's
work at most.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"ker_01" wrote in message
...
I think that kills my project.

I have code that pulls any appointment which includes "vacation" in the
title, and uses that to build a department vacation calendar. The problem
is
that some folks use recurring appointments (monday, but recur 3 times) or
long appointments (start Mon 7am, ends Thurs 3pm). Right now I'm trying to
set it up so that a person with shared viewing permissions can run the
program for our whole department, so we don't have to bug each person to
run
the code on their PC. In my example, the Thurs 3pm could mean 8 hours of
vacation if their worksday ends at 3pm, or it could mean 6 hours vacation,
if
their workday ends at 5pm. Eventually we'll have people in another time
zone, and that will make it even tougher to figure out.

I'm surprised, because I would have thought that it would be useful
information to have available to others who are scheduling appointments.
If
I'm scheduling an appointment with someone on the other coast of the US,
or
someone in Europe, it sure would be nice to see their workday (other times
greyed out as unavailable) so that I could be respectful of their
schedule.
Maybe that will be in Office2010...

Thank you,
Keith



  #6  
Old May 22nd 09, 10:11 PM posted to microsoft.public.outlook.program_vba
ker_01[_2_]
external usenet poster
 
Posts: 21
Default Retrieving work week (start/end times) from outlook with VBA

I didn't know how to do the registry monitor, but using your directions for
where to look in the registry, it was simple- posting here for future
searches on this topic.

Both the start and end times (Dwords) are hex representations of the number
of minutes into the day. So 7am = 7 hours x 60 minutes = 420 minutes; the hex
representation of 420 is 1a4. 6pm = 18 x 60 = 1080 minutes; the hex
representation is 438. Fortunately Excel has built-in tools to make the hex
conversion.

Of course, now that I'm thinking about it, that's only the final answer for
the local staff (people in the same time zone). I need to do some research on
how time zones will play into this as well...

Best,
Keith

"Ken Slovak - [MVP - Outlook]" wrote:

I don't think it will be in Outlook 2010.

I really don't see the problem. All it takes is a number of changes to the
work week settings, saved from Outlook, with checking the registry each time
to begin to see what patterns there are for the relevant settings. A
registry monitor set to filter on changes to only that registry key will let
you observe the results of every change. Then you would know what the
settings are, what they mean and how to work with them. Maybe a half day's
work at most.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"ker_01" wrote in message
...
I think that kills my project.

I have code that pulls any appointment which includes "vacation" in the
title, and uses that to build a department vacation calendar. The problem
is
that some folks use recurring appointments (monday, but recur 3 times) or
long appointments (start Mon 7am, ends Thurs 3pm). Right now I'm trying to
set it up so that a person with shared viewing permissions can run the
program for our whole department, so we don't have to bug each person to
run
the code on their PC. In my example, the Thurs 3pm could mean 8 hours of
vacation if their worksday ends at 3pm, or it could mean 6 hours vacation,
if
their workday ends at 5pm. Eventually we'll have people in another time
zone, and that will make it even tougher to figure out.

I'm surprised, because I would have thought that it would be useful
information to have available to others who are scheduling appointments.
If
I'm scheduling an appointment with someone on the other coast of the US,
or
someone in Europe, it sure would be nice to see their workday (other times
greyed out as unavailable) so that I could be respectful of their
schedule.
Maybe that will be in Office2010...

Thank you,
Keith



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Appointment times do not show in work week view Kaybee1 Outlook - Calandaring 2 October 1st 08 11:44 AM
work week times and availability rrupp Outlook - Calandaring 4 January 16th 08 11:52 PM
Show Start/End Times in Work Week always Sync-opy Outlook - Calandaring 1 December 5th 07 06:46 PM
How do I show start and end times on work week calendar? Debencore Outlook - Calandaring 1 August 15th 07 09:45 AM
Work Week and Times EXPLORER Outlook - Calandaring 3 April 12th 07 03:17 AM


All times are GMT +1. The time now is 08:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.