Thanks norie, I am getting late binding to work for access. Do you know how
get access reference to work with excel using late binding? or any sources
that I can refer to?

Thanks in advance

"norie" wrote:

So why do they need a reference to Access?

If you are the only person that needs it then you really should look
at late-binding, then you wouldn't have a problem with references.