I am needing assistance with creating a macro to automate the importing of a timesheet template from excel into outlook calendar. I have successfully performed the import by manually importing from the outlook menu but have not been able to get the code right in VBA.
|1||Start Date||Start Time||End Time||Location||Subject|
|2||8/8/2022||8:00:00 AM||4:00:00 PM||PP18P0048||STL Onboarding (Per Jeff A. Bowen)|
|3||8/9/2022||8:00:00 AM||11:00:00 AM||PM22P0020||SC Site Visit Rusty Y|
|4||8/9/2022||11:00:00 AM||2:30:00 PM||PP22P0021||SC Site Visit Rusty Y|