NotesSession.Initialize- how to avoid prompt?

I am using the following code in a VBA macro embedded into a Business Objects Report. I cannot Initialize the session witout prompting unless notes is launched. This is unacceptable. The documentation I’ve read on this site state if you do not provide a password you will be prompted. Well I’m hardcoding the same password as what I type into the prompt but get the prompt regardless. Only time I do not get the prompt is when my Lotus Client is already open.

Here is the code… simple enough.

'Domino COM Objects

Dim domSession As New Domino.NotesSession

Dim domNotesDBMailFile As NotesDatabase

’ Initialize Lotus Notes

domSession.Initialize ("<Password here>")

Set domNotesDBMailFile = domSession.GetDatabase("", "names.nsf", False)

Is there a notes client setting or notes Id I need to change?

Subject: NotesSession.Initialize- how to avoid prompt?

Examples that I’ve seen use

Dim domSession As New NotesSession instead of Domino.NotesSession.

Alternatively, the Createobject method works as well:

Dim lotusapp As Object

Set lotusapp = CreateObject(“Lotus.NotesSession”)