VBA Outlook Appointment Item "Start" Variables?

[Adam Flippo]

Hello all,

I have been working on an Outlook->Excel calender
export makro based on the well known Helen Feddema macro "Exporting Calendar Items to Excel".

Thank you very much to Helen for a very intuitive and easy to use macro!

I do, however have one question about possible Appointment.start and .end object variables:

Is it possible to change the output of the start object to the date/ time?

I would like to have the date and time output to 2 separate cells in excel.

I would like to have something like this:

Set rng = wks.Cells(i, j)
If itm.start <> "" Then rng.value = itm.startdate

j = j + 1

Set rng = wks.Cells(i, j)
If itm.start <> "" Then rng.value = itm.starttime

j = j + 1

Set rng = wks.Cells(i, j)
If itm.End <> "" Then rng.value = itm.Endtime
j = j + 1

Any help on this would be greatly appreciated.

Thanks,

Adam

 

[Michael Bauer [MVP - Outlook]]

Use the Format functon for that.

Date=Format(itm.Start, "mm.dd.yyyy")
Time=Format(itm.Start, "hh.nn.ss")

--
Best regards
Michael Bauer - MVP Outlook
Synchronize Color Categories & Ensure that Every Item Gets Categorized:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Thu, 29 Nov 2007 13:06:55 -0600 schrieb Adam Flippo:

 

[Adam Flippo]

Hi Michael,

thanks so much for your help!

Take Care,

Adam

 

[noie]

Hi !

I have the same problem as you Adam.
Can you explain me how you use the information that Micheal gives you ?

Thanks.