Community discussion forum

Use Excel VBA to create a Document in a Lotus Notes Database (not a mail or Memo document)

• • Reply

  6 months ago

  by gooner007

  Rob Mulhern

  London, United Kingdom

  Joined 6 months ago

  Hi,

  I need to be able to open a Lotus Notes Database (a document Library not mail) and then create a New Document in it . Currently I can open the database I need but can't create a new document. The code for opening the database is:

  Sub LotusNotes_CVXDocLib()

  Application.ScreenUpdating = False On Error Resume Next AppActivate "Lotus Notes" If Not Err.Number = 0 Then Err.Clear MsgBox "Notes is Not Running", vbInformation, "WSM-Marketing" Else Application.ActiveWorkbook.FollowHyperlink Address:="address", NewWindow:=True

  End If Exit Sub End Sub

  I now need to create a new Document so hope someone can help as I can't find anything about it.

  Cheers

  Post was edited on 22/05/2009 15:32:39 Report abuse