Amedee Van Gasse wrote:
when i try to do it with an
Excel-workbook it is protect by a password, it doesn't work
anymore.

I assume you are familiar with this page?
http://www.rondebruin.nl/ado.htm

I suppose the password should go somewhere in the connection string.

I assume you are not familiar with this page:

XL2000: "Could Not Decrypt File" Error with Password Protected File
http://support.microsoft.com/?KBID=211378

A workbook which requires a password to open cannot be read using ADO.

Jamie.

--