second bit first - If d = "" Or f = "" Then... or If d = "" And f = "" Then... rather than c style.
For the declarations you'd end up with
that is, it goes above any of the procedures in the module but, normaly, under the option statements
For the declarations you'd end up with
Code:
Option Compare Database
Option Explicit
Private Const strFilePath as String = "\\capt_kirk\conversion\data\caa"
Private strFileName As String
that is, it goes above any of the procedures in the module but, normaly, under the option statements