Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel/Lotus Notes
Does anyone know if it's possible to use Excell/VBA to link to a Lotus Notes
database? We currently have a small interface built in Excell which utilizes VBA to open reports on different drives and sub folders. We'd like to add reports that are housed in the Lotus Notes Database as well. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel/Lotus Notes
Stephanie:
Check and see if Notes is an OLE DB provider (I believe it is). If it is, you can use ADO to connect Excel to Notes "StephanieH" wrote: Does anyone know if it's possible to use Excell/VBA to link to a Lotus Notes database? We currently have a small interface built in Excell which utilizes VBA to open reports on different drives and sub folders. We'd like to add reports that are housed in the Lotus Notes Database as well. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel/Lotus Notes
Jared wrote:
Check and see if Notes is an OLE DB provider (I believe it is). If it is, you can use ADO to connect Excel to Notes And if it is an ODBC driver the OP can still use ADO e.g. via the OLE DB provider for ODBC. Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Lotus Notes with Excel Macro | Excel Discussion (Misc queries) | |||
Get Data from Lotus Notes Database into Excel | Excel Discussion (Misc queries) | |||
Has anyone sent emails from Excel via Lotus Notes? | Excel Discussion (Misc queries) | |||
Lotus Notes Doc LINK in Excel??? | Excel Discussion (Misc queries) | |||
Emailing Lotus Notes From Excel | Excel Programming |