Hello,
First of all please allow me to thank you in advance any assistance provided in this matter.
In an excel document I have a list of courses employees need to take, I want to have a VBA code that will create a calendar invite for every course listed in the document. The data is arranged as follows:
Column B: Dates the trainings will take place (ex 09/15/2017)
Column C: Duration of the training in minutes (ex 45 mins, 60 mins, etc.)
Column D: Time the training will take place (ex. 2:00 PM - 3:00 PM, etc.)
Column E: Training Title (ex "Drugs and Alcohol in the workplace")
The code should use the information in these columns to create the invite using the Training title as the subject for the invite.
Thank you,
First of all please allow me to thank you in advance any assistance provided in this matter.
In an excel document I have a list of courses employees need to take, I want to have a VBA code that will create a calendar invite for every course listed in the document. The data is arranged as follows:
Column B: Dates the trainings will take place (ex 09/15/2017)
Column C: Duration of the training in minutes (ex 45 mins, 60 mins, etc.)
Column D: Time the training will take place (ex. 2:00 PM - 3:00 PM, etc.)
Column E: Training Title (ex "Drugs and Alcohol in the workplace")
The code should use the information in these columns to create the invite using the Training title as the subject for the invite.
Thank you,