Export Outlook tasks to Excel

[jomili]

Trying to export Tasks to Excel. My code works well, except the code for my last row: It works "most" times, but "some" times it gives me a "Run time error:'1004': Method 'Range' of object '_Global' failed". I've searched and can't figure out what the problem is, so am appealing for help. My code is below and any help is greatly appreciated.

Please Login or Register  to view this content.

[Tinbendr]

You need to fully qualify the rows.count

Please Login or Register  to view this content.

[jomili]

Thanks David. That appears to be what was needed. Testing now, and I'll get back if I spot any other issues.

Thanks,
John

[jomili]

I've updated my code with David's suggestion. Now I have another "Sometimes" issue. Full code is below. I've installed it for 4 users (me included), and for 3 of us it works flawlessly. For one user, I'm getting an Error Code 13 on this line:

Please Login or Register  to view this content.

I can't find any difference in the setup. The only difference I see in him is that he's been using tasks in Outlook for a long time (years). We just recently upgraded to Outlook 2010, and most of our team is just staring to use tasks. I don't know if that difference could make the difference, but don't know what else it could be. Any help is appreciated.

Please Login or Register  to view this content.

[Tinbendr]

I'm going to take a wild guess and suggest that the Outlook database is corrupt. So, you need to add some error checking.

(Not tested)

Please Login or Register  to view this content.

[jomili]

TinBendr,
unfortunately I'm not going to be able to test this until late this afternoon, as the user in question is my boss, who's taking a 1/2 day off this morning. I'll try to get with him this afternoon and try it out. Thanks for this.

[jomili]

Update, in testing, I get a "Next without For" error. I've put the SKIP: down at the bottom, under my messagebox, like so:

Please Login or Register  to view this content.

How do I overcome the "For" error?

[jomili]

Got it working by changing my SKIP to:

Please Login or Register  to view this content.

Not sure if that's good coding, but it seems to work. Any help is appreciated.