Excel to Outlook Error 13 Data Mismatch when Creating Tasks

Hi all, I've been on the forums for a long time trying to figure out this problem but I just can't crack it so I'm looking for some help. I made a module which creates tasks in Outlook based on information in an excel file. When I run this Module it works BUT it still throws error 13 Data Mismatch for the due date on the task. It is particularly strange that it correctly puts the due date on the tasks but still throws the error.

Please Login or Register  to view this content.

When I run the module I get the tasks in Outlook but the line that says [ .DueDate = DateValue(strDate) ] is highlighted and a popup appears and says "Run-time error '13': Type Mismatch". I've been thinking that the issue might be stemming from some sort of data formatting conflict between what it is in excel versus what it needs to be for outlook. I have the dates set in the Date format in Excel that doesn't take into account the computer regional settings, which I think would be best.

I have seen other posts where people post very similar code that worked for them which just leaves me more confused. Any help would be greatly appreciated.

Thank you,
Kire

Thank you for the quick reply. I had tried doing as you suggested a few times earlier today and it always failed, but now I see that I forgot to change all the "str" prefixes to "dt" so I changed them. However now it gives me error 13 mismatch error for the line:

Please Login or Register  to view this content.

So overall this is what it looks like

Please Login or Register  to view this content.

The cells being references grab values from other cells in the same worksheet and those cells grab data from other cells across a lot of other worksheets. What kind of issue should I be looking for? Does every cell that could possibly be used need to all be a certain format?

The ones being directly referenced (Column E) were in the date format of 3/14/12

Thanks,
Kire

The date that shows up in the Outlook task is correct from Column E.
It is just so weird that the dates transfer correctly but the error still shows up...