Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Briefly stated..code to open Notes database and find a specific doc...cant
iterate through all there are 166,000 of them my code as is below.... ndoc comes back as a long i believe a Notesentry key...so where do i go from here ??? ' set up variables ... Dim Domdb As NotesDatabase 'database contaiing names/groups Dim nsdc As NotesDocumentCollection 'doc collection returned from query Dim ndoc As NotesDocument 'notes doc Dim ndoc1 As NotesDocument 'notes doc Dim varColNames As Variant 'for col val and column name arrays Dim varColVals As Variant ' open a session ... Set Session = CreateObject("Lotus.NotesSession") Call Session.Initialize ' get the database we are looking at from drop down ... strmisc = Trim(Me.cbDatabaseList.Value) Set Domdb = Session.GetDatabase(Me.txtNamesServer, Me.txtNamesFile) ' check if open If (Not Domdb.IsOpen) Then strmisc = "The names database: used to identfy indiviual in groups could not be opened" MsgBox strmisc, vbInformation, "Error Opening names Database" End If ' look up the first group ... Set nsdc = Domdb.FTSearch("GAD-WP Admin", 0) Set ndoc = nsdc.GetFirstDocument |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. | Excel Programming | |||
database to Find customer by zip code | Excel Discussion (Misc queries) | |||
how can i find a specific date of a database | Excel Discussion (Misc queries) | |||
VBA code to open a specific worksheet | Excel Programming | |||
Post file to Notes database | Excel Programming |