I have a couple questions regarding a program I'm working on that exports information from an Excel schedule to Outlook Calendar and Tasks:

1) 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 Calendar up to date. How can I have the macro erase all items from the Outlook Calendar with a given address before it exports my dates? In other words: I run the Macro; it scans the outlook calendar and erases all entries with an address of "123 Anywhere St"; then it scans my list of dates and copies them to the Calendar. I already have the part written that scans my list of dates and copies them to Excel, it's just the erasing part I need help with. Also, how would I have Excel erase all events in Tasks with a given property?

2) in cell A1 i have some text. in cell B1 i have a date. how do I get Excel to display both the text and the date. I've tried:

Dim olDate As Range
Dim olText As Range
Set olDate = Sheet1.Cells.Item(1,"A")
Set olText = Sheet1.Cells.Item(1,"B")
.Subject= olDate + olText

hoping to get something like "some text 6/9/05" in the subject bar, but everytime I do this i get a run time error. i've tried replacing the date with text and it works just fine, and i've also tried just the date cell and it works fine. the problem comes up when i try and combine the date and text. both

Any help would be much appreciated. Thank you in advance.