Outlook 2003 calendar events into Excel 2003?

[Kolin Tregaskes]

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

 

[Guest]

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]

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

 

[Guest]

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]

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