Excel Automation and Windows Vista

If you find that you have the following error

Automation error
Library not registered.
-2147319779

When trying to run automation code in Access 2003 and Vista, you need to change the automation code to late binding from early binding.

ie This means remove the reference to Excel

Dim objXLApp As Excel.Application

and change it to

Dim objXLApp As Object

Read more

http://www.granite.ab.ca/access/latebinding.htm

Garry Robinson