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.


--
littlegreenmen1
------------------------------------------------------------------------
littlegreenmen1's Profile: http://www.excelforum.com/member.php...o&userid=23978
View this thread: http://www.excelforum.com/showthread...hreadid=377906