CODEWITHSUNDEEP
vbaexcelhyperlinklotus-notes
user1545751
user1545751

Reputation: 11

Opening an Excel file attachment located in a Lotus Notes Database through VBA

I am trying to automate the opening of an excel file located in a jobs database within lotus notes. I have been able to open up a window in lotus notes using the url, but I can't open the file located there automatically as it is an attachment.

This is the vba code I am using to open the link:

Application.ActiveWorkbook.FollowHyperlink Address:="Notes://URL", NewWindow:=True

What is the proper way to do it?

Upvotes: 1

Views: 5571

Answers (1)

Ken Pespisa
Ken Pespisa

Reputation: 22284

You'll need to use VBA to access Lotus Notes via COM. Then you can get at the NotesEmbeddedObject, save it using the ExtractFile method, and then launch that saved copy.

An example of VBA using Notes COM API: http://www.vbafin.com/Lotus-Notes-VBA-code.php

There's a document on IBM's site that will help you get started:

How to use LotusScript classes with Visual Basic

Upvotes: 1

Related Questions