Paul...

ADO cannot reliably query opened workbooks.
see
http://support.microsoft.com/default...b;en-us;319998

it will lead to memory leaks, and may cause excel instance
to become 'uncloseable'


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Paul - NottsUK wrote :

Robert,

It probably is neater but I still end up with a ghost process at the
end.

Paul

"Robert Bruce" wrote:

Paul - NottsUK wrote:
Are you sure you need this:

Set appXL = GetObject(, "Excel.Application")

if you're coding in Excel?

Wouldn't

Set appXL = Application

work better?

Rob