Thread: Late Binding
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E[_2_] AA2e72E[_2_] is offline
external usenet poster
 
Posts: 93
Default Late Binding

(ADO) ActiveX Data Object 2.5 Library

Dim ADOR as Varian
Set ADOR = CreateObject("ADODB.RecordSet"

to talk to your databased, you need

Cnn={connection string, usually ODBC
Sql =P SQL statement

You should have these already

ADOR.Open Sql, Cnn ' Opens the database and returns the result of your SQ

ADO has several other object hierarchies, Connection, Stream, et

OUTLOOK

Dim OLK as Varian
Set OLK = CreateObject("Outlook.Application"

DOWNSIDE: 1. No intellisense with late bindin
2. You need to hard code predefined constants

For ADO: Download the MDAC SDK from Microsoft
For OUTLOOK: I has a reference to a Microsoft page ... can't remember right now ... will send another message if I remember