Transfer data from Excel to Outlook Calendar

Hi,

I have some data in my excel sheet, see picture.
Now I want to transfer it to Outlook Calendar.

http://img252.imageshack.us/img252/6...enshot032a.jpg

How can I do that?


I hope someone can help me

I also have a CSV file, if that is easier.

Just let me know if you want more information!

Thanks John!

Attached you can find my excel workbook. It is the 2nd sheet that I use when I transfer to Outlook, and the sub I have edited is "Transfer_Outlook" (the one at the top of the module).

It is not working correctly, do you know what's wrong? Nothing is correctly transferred, and I am not a master in VBA.

I look forward for help

-Idar

This line of code evaluates to 100

It is because I need to use the sheet for several school subjects, such as math, finance, economy and so on. Therefore I don't know how many rows that are filled. In sheet 1 I paste my school schedule from our web solution (one by one), and I sort it in the second sheet and use IF-formulas. Since different subjects may have different numbers of lessons, I did it that way. Is there a way to fix it?

About the secondly, I actually don't know why it is there. I pasted it from the link you sent me. I don't know very much about programming, I usually use the recorder.

What I want to do is transferring from Excel to Outlook Calendar with:
Subject: Column A
Start date: B
Start time: C
End date: D
End time: E
Place: H
Category: I
Body: 1.line: F. 2.line: G
Reminder: None

PS! I have deleted the column "All day event".

Do you understand what I want to do?


Thank you so much for your help; I really appreciate it!!

Let me know of issues.

I have only one question. It don't categorizes. Do you know what's wrong?

Let me know of issues.

Hi again, and thank you for responding

In Outlook I have a category called "Skole" (Norwegian for school).
I have tried both "Category", "Categorise" and "Categorize" without any luck.

Do you know what's wrong; and is it working for you?

Oh, I must have miss-spelt it. Now it works great!

Thank you so much for help and patience I couldn't have done this without you!

That is to be done.
My last question: is it possible to owerwrite existing appointment? It is not important, but if it can be done with one line or so, it would have been perfect. If it is some work with it, don't use any more time on my problem. I have achieved what I wanted to do; thank you so much!

I thought that if I transfered appointment that allready existed with same subject and time, the old one should have been overwrited.
Don't think about it, I am more than satisfied

Thank you again