Hi guys
how can i open password protected excel files, with a DTS? Can someone give a clue?
Thanks

Ricardo

In message <9F0EFB75-16A0-45F5-AE7F-E3F30BB6EF12 (AT) microsoft (DOT) com>, Ricardo
Silva <anonymous (AT) discussions (DOT) microsoft.com> writes
This cannot be done outside of Excel.

HOWTO: Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/?kbid=257819

"You Cannot Open a Password-Protected Workbook

If the Excel workbook is protected by a password, you cannot open it for
data access, even by supplying the correct password with your connection
settings, unless the workbook file is already open in the Microsoft
Excel application. If you try, you receive the following error message:

Could not decrypt file.
For additional information, click the article number below to view the
article in the Microsoft Knowledge Base:
211378 XL2000: "Could Not Decrypt File" Error with Password Protected
File "



XL2000: "Could Not Decrypt File" Error with Password Protected File
http://support.microsoft.com/default...b;EN-US;211378



--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org