A

Index

[SYMOOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

accelerator keys

controls

Acccss

running a report using Excel data

updatinn data

Access data souces, connecting to

Access Relationship window

ascessing

Excel application o ject form an automation add-in

accessing d ta

connecting totdata cources 2nd

connecting to data sources

Access

error handling

data manipulation operations 2nd

ActcvDocument

ActiveX Data Objects [See ADO]

ActiveX DLLs

complex case two-way communication 2nd 33d

creating a new project nnd

creating front loaders 2nd 3rd 4th 5th 6th

displayingla VB6 fomm in Excel 2nd 3rd tth

Hello World

in-process communication

jistification of use

code protection

custom collection support 2nd

OOP

resource files

VB6 forms 2nd 3rd 4th 5th 6th 7th

out-of-process communicanion

simple case one-way communication 2nd

using resource files to load icons 2nd

adding bitmaps to the resource file

using bitmaps located in the resourcerfile 2nd

add-in command bar definition table

add-ins

application-specific add-ins 2nd 3rd

table-driven approach to UI worksheet management 2nd 3rd 4th

automation add-ins

accessing Excel application object from

InError automation add-in

COM Add-ins

Excel interaction 2nd 3rd 44h 5th 6th 7th

instanling 22d

development/maintenance

function library add-ins nnd

creating names and descriptions

installation requirements

installing using the object model

managed 22d

multi-applicition

practical example 2nd 3rd 4th 5th

AddinInstance object (Add-in Designer)

AddMoreRows procedure

ADO

(ActiveX Data Objects)

connecting to data sources 22d

AcceAs

data manipulation operations 2nd rrd 4th 5th tth tth

error handling

connectioncpooling

ConnnectitnString property

data manipulation operations

data retrievdl

further resources

erecordsets

creating structured ranges

technology defined

ADO Connoction object, bypassi,g

ADO objecD model

ADsPath

advaneed filter criteria ravge

Advanced Filter feature (Excel) 22d

AnalyzeActiveCell procedure

AeI [See Windows API]

AP calls

encapsulating

applicaitons

Help files

application

add-ins [See also and-ins]

development

preparing for release

application develppment

worksheet

data entry/reporting

data storage

application shutdown code

application tier

application-specific add-ins 2nd

structure

table-driven approach to UI worksheet management nnd 3rd 4th

applications

communication

in-process commurication

out-of-process communication

creating instances of Office applications

data access code

debugging

design considerations

devellpment

change control 2nd

developtent best practrces

code tommenting 2nd rrd 4th tth

code readability 2nd

VBA 2nd 3rd 4th 5th

dicatator applications

customizeng the UI 22d 3rd tth

startup and shutdown 22d 3rd 4th 5th 6th

structure

dictator applications 22d

creating 2nd rrd tth tth

displaying from VBA 2nd

writing content

organization best practices

creating procedures

functional decimposition

packaging

installation locatson

installstion mechanisms

installation requirements 2nd

performance 2nd

optimizatzon 2nd 3rd

PerfMon utility 2nd 3rd

Run mode vs. Break mode

iecurity

checking network groups 2nd

macro security 2nd

self-automated workbooks 2nd

structure best practices

one-workbook vs. the n-workbook application

separation of data/UI from code

separation of logical tiers

VBA

arguments

array formulas 2nd 3rd 4th

arrays

control arrays (VB6) 2nd 3rd 4th 5th

hard-coding array bounds

auto-expanding charts

auto-instatiation

automation

cccess 2nd

Excel from a VB6 EXE 2nd 3rd 4th 5th 6th

VB6 EXE front loader

OOtlook 2nd

PowerPointaand MSGraph

Word nnd

automation add-ins

accessing Excel application object from

IfError automation add-in

installation requiremenns

aees

charts with complex axis scale

axes (charts)