mrccopeland
Programmer
Hello All,
I've searched the documentation here on vba and lotus notes but have come up short. Most topics here deal with sending messages via lotus notes. The problem I have here deals with reading the contents of a view and writing those contents back to excel. I assume you could use currentdatabase and such but am not that familiar with scripting for Lotus Notes. Any help would be tremendously appreciated.
The Problem:
Read a selected lotus notes view into an excel spreadsheet via excel vba.
The Specifics:
1. Programatically select the database if you are a user and not the owner of the database. (It's a shared LN DB where specific issues are stored)
2. Read the contents of the view (just the fields displayed on the view) and insert them into separate cells on the spreadsheet (sequentially)
3. Insert a lotus notes doclink in the last excel column that would link back to the document in lotus notes (actually open the document).
Pointers/Tips/Where to look, really appreciated.
I've searched the documentation here on vba and lotus notes but have come up short. Most topics here deal with sending messages via lotus notes. The problem I have here deals with reading the contents of a view and writing those contents back to excel. I assume you could use currentdatabase and such but am not that familiar with scripting for Lotus Notes. Any help would be tremendously appreciated.
The Problem:
Read a selected lotus notes view into an excel spreadsheet via excel vba.
The Specifics:
1. Programatically select the database if you are a user and not the owner of the database. (It's a shared LN DB where specific issues are stored)
2. Read the contents of the view (just the fields displayed on the view) and insert them into separate cells on the spreadsheet (sequentially)
3. Insert a lotus notes doclink in the last excel column that would link back to the document in lotus notes (actually open the document).
Pointers/Tips/Where to look, really appreciated.
