Erasing Outlook Calendar from within Excel

L

littlegreenmen1

I have several schedules in different Excel files that I need to export
I need to run the exporter from each file everyday to keep my Calenda
up to date. How can I have the macro in each Excel file erase all item
from the Outlook Calendar with a given address before it exports m
dates? In other words: I run the Macro; it scans the outlook calenda
and erases all entries in my Outlook Calendar with an address of "12
Anywhere St"; then it scans my list of dates and copies them from Exce
to my Outlook Calendar. I already have the part written that scans m
list of dates and copies them to Excel, it's just the erasing part
need help with. Right now when I run my macro to scan and export th
dates it simply adds to the Calendar. If I already ran it once then
run it again, I'll have duplicate entries in Outlook. Also, how woul
I have Excel erase all events in Tasks with a given property (for th
same reasons as the Calendar)? Thank you for the help
 
Top