VBA- office requirements

[Patrick]

Is it possible to run an Excel based VBA that manipuate data in an Access
database on a client PC that does *not* have Access installed (i.e., it only
has Excel).

I know it is definitely possible to develop such a VBA in Excel in the first
place (by adding the Access Dll reference in the VBA project), but not sure
in run time whether Access needs to be installed or not? (Let say, if DAO
or ADO is used).

 

[Howard Kaikow]

Excel can play with an Access database directly.
Does not have to go thru Access, you can directly access, pun intended, the
database using, say, DAO or ADO.