export excel to outlook calendar

**dollar** · 08-11-2009, 09:30 AM

i am using the attached sheet to export data from excel to outlook calendar from last 2-3 months. Now suddenly it stopped working for me (I didn't amend the code)

All the data i have filled in is in the correct format but the code doesn't export the data after ROW 72.

Dunno what the hell is wrong with this code .

Please help me out.

Thanks in advance.

**DonkeyOte** · 08-11-2009, 10:06 AM

the code looks ok per se but some of your end times precede the start times ... to illustrate:

F2: =SUM(A2,C2)>SUM(B2,D2)
copied down for all entries

where TRUE you are likely to experience "issues"... why TRUE - well some of the time values include the Date portion too .. eg C78 is 2/1/1900 08:00 which equates to 56 hours (2 days and 8 hours)

**dollar** · 08-11-2009, 10:25 AM

ok but what's the solution ?

**DonkeyOte** · 08-11-2009, 10:27 AM

... to ensure your start times precede your end times ... and more specifically to ensure your time values are < 24 hours.

**dollar** · 08-11-2009, 11:30 AM

why does the time duration should be under 24 hours ?
Kindky re-check this attached file .

Thanks

**dollar** · 08-11-2009, 11:35 AM

& one more thing; is there any userform for filling up time values in column C & Column D (like we use calendar form to fill in dates) ?

Thanks

**schmidtpainting** · 12-22-2013, 10:14 AM

Originally Posted by dollar

i am using the attached sheet to export data from excel to outlook calendar from last 2-3 months. Now suddenly it stopped working for me (I didn't amend the code)

All the data i have filled in is in the correct format but the code doesn't export the data after ROW 72.

Dunno what the hell is wrong with this code .

Please help me out.

Thanks in advance.

Did you ever solve this problem?

If so I would like to hire you to do the same for me.

I have a excel sheet that using outlook file names and I need to sync the excel sheet to the outlook calendar.

Please get back to me.

Thanks Derrick