Question: How do I access a Notes teamroom from an Excel Macro

HCL Domino Domino Forum
1

Does anyone know th ecode needed to access a notes teamroom from a VBA macro in EXCEL? I need to access the teamroom and then open up other excel workbooks within the teamroom

2

Subject: You have to create Notes Object in your macro.

The first question is:

  1. is Notes Open when you try to execute this ?

  2. The person who is using Notes, have the access to this database.

If all this is true, you can Create a NotesSession, and then a NotesDatabase ( pass the parameter of who is your team room application).

Then, Find the document ( by key, or by NotesID ). Detach the Excel File, and then read it.

Is quite complex, if you doesn’t understand the Notes Arcuitecture.

3

Subject: Do you have sample code

The users will have notes up and access to the Teamroom. Do you have any sample code that I can look at to get a feel for how access is done. or a pointer to where it is documented.