Macro to input appointment in Outlook shared Calendar using data in Excel

[Garouken]

Hi please bare with me as my knowledge of vba is limited, I am trying to get a row of information lets say the following

Description, start time, end time , date, Location

i want to be able to use this information to populate an appointment in a shared calendar located in " \\All public folders\WFD\bookings "

I have had some success with getting this to work for my default calendar but i cant seem to get it to send to the shared calendar and i am at the end of my rope