Dates from Excel to Outlook appointments

[finfly]

New here, hi to all! I've been coding in Matlab etc. before but VBA is uncharted territory.

I have a sheet where in A column are heading information and in B column are the dates. I column contains additional information. I've been working on a macro that makes Outlook appointments (whit alarm) from this data. As the progress is automated the code also checks for duplicated appointments.

My system and Excel uses EU date format.

After three days of work I still have two problems:
-Date formatting brakes in VBA. All my appointments are in Outlook in 30.12.1899 not i.e. 25.11.2013 I have in Excel. I guess problem is the date format Excel uses is EU dates and VBA works in American format in for/if loop
-I do not get Excel to read value from A column to subject of appointment or value from I column to body text of appointment. Instead subject is blank and in body is only the standard text.

Any help would really be appreciated! And sorry about my language, English is not my native language.

Piecing together from internet sources and my knowledge I have a code:

Please Login or Register  to view this content.

[finfly]

After a weeks work I'm closer to solution.

Now I have in A colum heading information and dates are in B or D columns. Code detects existing entries and does not create duplicates.

I still would like the code to create new appointment when date changes.I've tried many solutions, this is closest I got.

Any help how I could create it to my macro? Please?

Please Login or Register  to view this content.

Or the other way: replasing the find loops with delete loop. It deletes around half of old entries. What's wrong here?

Please Login or Register  to view this content.

[finfly]

I finally craced it. Because I got the code from the general onlinw community I share it to the community.

This code looks A colum for subject and B for date. If B containst text it gets date from E column. All this it combines to Outlook appointment. Program also detects changes in dates.

Please Login or Register  to view this content.