View Single Post
  #5  
Old May 22nd 09, 06: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



Ads