Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using XL to grab current user's Outlook calendar item titles, dates, and durations?
I work in a team of about 30 people. We document our vacation in MS Outlook
(so folks know we are gone) and again in an Excel workbook, which adds up all our documented hours of vacation for the whole year (including scheduled vacation that has not yet occurred). Everyone has access to the Excel worksheet on our network, and their own calendar in MS Outlook. It seems to me that an easier (and more accurate) solution would be to create a macro in the excel workbook, so that when triggered, it would go out and check (at minimum) the individual user's vacation time and update it in their Excel sheet. I'm ok with using VBA inside of excel, and I can get the current user's login ID. But.... I haven't done anything at all with Outlook, so can anyone point me in the right direction? I'm looking for code snippets and/or keywords that I should be looking at to have Excel VBA cycle through all of the current user's calendar entries (for the target year) and pull the subject line, date, and duration. I'll then parse the subject lines to look for a standardized keyword that indicates vacation, and if I find it, put that date and duration in the excel worksheet that corresponds to that individual. Thanks in advance, Keith -- The enclosed questions or comments are entirely mine and don't represent the thoughts, views, or policy of my employer. Any errors or omissions are my own. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using XL to grab current user's Outlook calendar item titles, dates, and durations?
Keith
This should get you started http://www.dicks-clicks.com/excel/ol...an_Appointment -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "KR" wrote in message ... I work in a team of about 30 people. We document our vacation in MS Outlook (so folks know we are gone) and again in an Excel workbook, which adds up all our documented hours of vacation for the whole year (including scheduled vacation that has not yet occurred). Everyone has access to the Excel worksheet on our network, and their own calendar in MS Outlook. It seems to me that an easier (and more accurate) solution would be to create a macro in the excel workbook, so that when triggered, it would go out and check (at minimum) the individual user's vacation time and update it in their Excel sheet. I'm ok with using VBA inside of excel, and I can get the current user's login ID. But.... I haven't done anything at all with Outlook, so can anyone point me in the right direction? I'm looking for code snippets and/or keywords that I should be looking at to have Excel VBA cycle through all of the current user's calendar entries (for the target year) and pull the subject line, date, and duration. I'll then parse the subject lines to look for a standardized keyword that indicates vacation, and if I find it, put that date and duration in the excel worksheet that corresponds to that individual. Thanks in advance, Keith -- The enclosed questions or comments are entirely mine and don't represent the thoughts, views, or policy of my employer. Any errors or omissions are my own. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using XL to grab current user's Outlook calendar item titles, dates, and durations?
Awesome, I'm already halfway done now!
Thanks for the link, Keith "Dick Kusleika" wrote in message ... Keith This should get you started http://www.dicks-clicks.com/excel/ol...an_Appointment -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Outlook Calendar event from dates in excel | Excel Discussion (Misc queries) | |||
dates from excel onto outlook calendar | Excel Discussion (Misc queries) | |||
Can future dates on Excel be managed in Outlook calendar? | Excel Worksheet Functions | |||
Export Excel Dates to Outlook Calendar? | Excel Worksheet Functions | |||
Dates in Excel linked with Outlook Calendar | Excel Worksheet Functions |