Linking excel cells containing date and time to appointment in outlook

[MyExHell]

Hi all....

can anybody help with some code to create an appointment in an Outlook calendar, it will need to go to a shared calendar which isn't the default calendar on outlook.

The cells to determine the appointment are on a worksheet named "Next Actions"

A2 - contains Date (cell is formatted to date format)
B2 - contains the time (currently formatted to text)
C2 - the user who has requested the appointment
D2 - contains the action that's needed

Many thanks

[MyExHell]

Hi all. Before I waste anytime looking for a solution to this one does anyone know if its actually something that can be achieved?

Thanks