Filling arrays with Calendar items

  • Thread starter Thread starter devlei
  • Start date Start date
D

devlei

I use a "For Each objItem in objItems" loop to go through all the
items in my Calendar folder, in order to place data into different
arrays according to the items Category.

The problem is that it seems to take too long. For the approx 400
items in the folder, it takes 30 seconds. Is this normal?

Working with the same arrays thereafter and doing similar data
processing is virtually instant, so the fault doesn't seem to be with
the arrays, but with the looping through the Calendar items. Does this
sound correct? I seem to remember that when using Outlook's Import
and Exporting command to export to Excel or Access, the process also
takes a long time to complete.

With thanks
Dave
 
Hi Dave,

unfortunately for the OOM this is normal. You can use CDO instead. It´s
optional and you maybe have to install it first from your Office-/OL CD.
 
Back
Top