Hi All,
I have written some VBA code to pull calendar information from the user's outlook into and excel s/sheet so we can quickly and easily do team time reporting. So far so good but I have hit a brick wall on two tweaks to the code:
1. I don't want to pull through entries marked as Private (happy if the solution pulls them into excel and then deletes them, as long as they don't show once the code has stopped running)
2. I don't want to show things where the time is classed as "free" (under "show time as" in Outlook)
My issue is that I can't seem to work out which object group these classifications sit under so can't identify them. Anyone got any tips (or a cheeky sub routine I can call onto do the magic?!)?
Many thanks,
Karmink
I have written some VBA code to pull calendar information from the user's outlook into and excel s/sheet so we can quickly and easily do team time reporting. So far so good but I have hit a brick wall on two tweaks to the code:
1. I don't want to pull through entries marked as Private (happy if the solution pulls them into excel and then deletes them, as long as they don't show once the code has stopped running)
2. I don't want to show things where the time is classed as "free" (under "show time as" in Outlook)
My issue is that I can't seem to work out which object group these classifications sit under so can't identify them. Anyone got any tips (or a cheeky sub routine I can call onto do the magic?!)?
Many thanks,
Karmink