Are you trying to create an excel sheet from lotus notes data? If so then take a look at this —> http://criverapr.blogspot.com/2008/10/using-poi-to-export-lotus-notes-data-to.html. If not, can you give more details on what you want to accomplish?
If your code is written in VBA, all your need is (love ?) here :
* Initialize: this method can be used on a computer with a Notes client or Domino server and bases the session on the current user ID. If a password is specified, it must match the user ID password. If a password is not specified, the user is prompted for a password as required and as the software permits. If the software does not support prompting (for example, VBScript under ASP/IIS), you must supply the password or the user ID must not have one.
* InitializeUsingNotesUserName: this method can be used only on a computer with a Domino server. If a name is specified, the InitializeUsingNotesUserName method looks it up in the local Domino Directory and permits access to the local server depending on the “Server Access” and “COM Restrictions” settings. The password must match the Internet password associated with the name. If no name is specified, access is granted if the server permits Anonymous access.
I have managed to solve this problem by using “SendKeys” from vba to login. Thanks to all for your responses. It is much appreciated.