Yes this is all code in Excel, but sure you could drop same code into Word, Power Point, etc. Could do the same with ADO, but prefer to stick to the native access interface DAO when working JET. I assume if this was in Access you would just link to those tables in the external dbs. Still...