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

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

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

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

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