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. 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, Selects a view (which I may change to selecting all documents) 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. >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? I'm using Excel2007 and Lotus Notes 6.5 (Lotus Notes Designer is no help either!) Thank you, Paul Schreiner -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel