I receive an Excel file weekly among 30 other files that are password
protected. I'd like to set up a DTS so that I can automate the imports
without having to tell my client to remove the password each time - is this
possible?

I think about as far as you can get is the cannot decrypt
file error. See the following:
XL2000: "Could Not Decrypt File" Error with Password
Protected File
http://support.microsoft.com/?id=211378
The following also has a reference to this issue:
http://support.microsoft.com/?id=257819

-Sue

On Tue, 13 Jun 2006 14:08:02 -0700, jonefer
<jonefer (AT) discussions (DOT) microsoft.com> wrote: