Excel VBA Read Lotus Notes database section title

[pmschreiner]

I've posted this in other forums, with NO reponses, so I apologize for cross-posting...

I'm using Excel2007 and Lotus Notes 6.5
(Lotus Notes Designer is no help either!)

Many years ago, a developer for several of our Lotus Notes databases
decided to "Protect" some Authorization data by adding it to the Title of a Lotus Notes "Section".


Sadly, he is no longer with us.

We are in the process of migrating our Databases to another platform, and I am exporting the database to a format that can be merged to the new location.

However, I would like to extract this Authorization from the Title of
the Section.

I've got LOTS of VBA code that opens the Lotus Notes Database,
Loops through the view and selects each document.

I can extract all of the normal "fields" in each document, but cannot
seem to be able to get to the Section(s) and their titles.
(Even though I can access Fields WITHIN the section.)

From what I can gather, I need to use the NotesRichTextNavigator
and the NotesRichTextSection class,

But cannot seem to get any of the examples to work!
Has anyone done anything like this?
Can you provide guidance?