VBA Outlook Appointment Item "Start" Variables?

  • Thread starter Thread starter Adam Flippo
  • Start date Start date
A

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
 
Hi !

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

Thanks.
 
Back
Top