Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Outlook 2003 calendar events into Excel 2003?
Hello,
I would like an Excel sheet that grabs my calendar events (i.e. to have a list of my Outlook calendar events, such as people's Birthday's, in an Excel sheet and updates whenever you open up the Excel sheet. A lookup formula would be useful as I already have a list of the year's dates with my hours worked, sunrise and last's average temperatures for each day. Is this possible in some way? Kol |
#2
|
|||
|
|||
Kolin,
I have posted an example of how to navigate the Outlook Object Model to: http://www.Galimi.com/Examples/Outlook.xls http://HelpExcel.com "Kolin Tregaskes" wrote: Hello, I would like an Excel sheet that grabs my calendar events (i.e. to have a list of my Outlook calendar events, such as people's Birthday's, in an Excel sheet and updates whenever you open up the Excel sheet. A lookup formula would be useful as I already have a list of the year's dates with my hours worked, sunrise and last's average temperatures for each day. Is this possible in some way? Kol |
#3
|
|||
|
|||
Hi there,
Thanks for the link, I get a runtime error when I click on the button. Do you have an example for Calendar import? Sorry, not a programmer. Kol "galimi" wrote in message ... Kolin, I have posted an example of how to navigate the Outlook Object Model to: http://www.Galimi.com/Examples/Outlook.xls http://HelpExcel.com "Kolin Tregaskes" wrote: Hello, I would like an Excel sheet that grabs my calendar events (i.e. to have a list of my Outlook calendar events, such as people's Birthday's, in an Excel sheet and updates whenever you open up the Excel sheet. A lookup formula would be useful as I already have a list of the year's dates with my hours worked, sunrise and last's average temperatures for each day. Is this possible in some way? Kol |
#4
|
|||
|
|||
http://HelpExcel.com
Following is some example code Sub getOutlook() Set myOLAPP = CreateObject("Outlook.Application") Set mynamespace = myOLAPP.GetNamespace("MAPI") Set myaddresslist = mynamespace.Folders(1).Folders("Calendar").Items For Each strItem In myaddresslist shtImport.Range("a2").Offset(r) = strItem.Subject r = r + 1 Next Set oOL = Nothing End Sub The only way I know of to create an active link between Outlook & Excel is programmatic. "Kolin Tregaskes" wrote: Hi there, Thanks for the link, I get a runtime error when I click on the button. Do you have an example for Calendar import? Sorry, not a programmer. Kol "galimi" wrote in message ... Kolin, I have posted an example of how to navigate the Outlook Object Model to: http://www.Galimi.com/Examples/Outlook.xls http://HelpExcel.com "Kolin Tregaskes" wrote: Hello, I would like an Excel sheet that grabs my calendar events (i.e. to have a list of my Outlook calendar events, such as people's Birthday's, in an Excel sheet and updates whenever you open up the Excel sheet. A lookup formula would be useful as I already have a list of the year's dates with my hours worked, sunrise and last's average temperatures for each day. Is this possible in some way? Kol |
#5
|
|||
|
|||
Hi again,
Thanks for your reply, but this is just Latin to me, sorry. What would I do with this code? Does anyone else have any suggestions please? Kol "galimi" wrote in message ... http://HelpExcel.com Following is some example code Sub getOutlook() Set myOLAPP = CreateObject("Outlook.Application") Set mynamespace = myOLAPP.GetNamespace("MAPI") Set myaddresslist = mynamespace.Folders(1).Folders("Calendar").Items For Each strItem In myaddresslist shtImport.Range("a2").Offset(r) = strItem.Subject r = r + 1 Next Set oOL = Nothing End Sub The only way I know of to create an active link between Outlook & Excel is programmatic. "Kolin Tregaskes" wrote: Hi there, Thanks for the link, I get a runtime error when I click on the button. Do you have an example for Calendar import? Sorry, not a programmer. Kol "galimi" wrote in message ... Kolin, I have posted an example of how to navigate the Outlook Object Model to: http://www.Galimi.com/Examples/Outlook.xls http://HelpExcel.com "Kolin Tregaskes" wrote: Hello, I would like an Excel sheet that grabs my calendar events (i.e. to have a list of my Outlook calendar events, such as people's Birthday's, in an Excel sheet and updates whenever you open up the Excel sheet. A lookup formula would be useful as I already have a list of the year's dates with my hours worked, sunrise and last's average temperatures for each day. Is this possible in some way? Kol |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2003 Calendar Pop-Up Add-In | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Excel 2002 vs Outlook 2003 | Excel Discussion (Misc queries) |