View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
donbowyer donbowyer is offline
external usenet poster
 
Posts: 107
Default Import Outlook Journal Items into Excel

I'm using Excel & Outlook 2003 on Win XP
I use Outlook Journal , with the entries listed in descending chronological
order.

Part of the code I'm using successfully to import Journal entries into Excel
is:-
"For Each olJourItem In olJourFolder.Items"
However the Journal entries are imported in ascending chronological order
or, with the last entry first.
I assume this is a quirk of the For Each ..... procedure.
How might I modify this code to import in the reverse order?

--
donwb