Excel macro - export to Outlook .ics

Hey!

I have this macro in Excel which exports events to an .ics file that i can open with Outlook Calendar. It automaticly populates the calendar with information in the Excel document:

Please Login or Register  to view this content.

It works perfectly however I wan't to do a few modifications to fit my needs. I know absolutely nothing about coding these macros, so I need someone to help me out.

Additionally I wan't to:
- Pick up dates from column 'H' instead of 'B'. (I've tried to just change B to H, but that didn't work)
- Make the events all day events, so that the starting/ending time is not showed up in the calendar, but only the title/name.
- Put in a reminder 1 week before.
- Place all the events in a category.
- Include additional information (more columns). I have a column for location info, aswell as a column for description. I wan't the macro to recognize these columns as location and description.

I hope it's not too much of a trouble to make the modifications.


Thanks!

Best regards
Jeppe C.