Gustav Brock
gustav at cactus.dk
Fri May 7 12:25:38 CDT 2004
Hi Marty Yes, that's my conclusion as well. /gustav > I didn't know this but I am afraid you are hooped. > You cannot use ADO to read a password-protected Excel workbook. > The reason is that protecting it with a password actually encrypts the > workbook on disk > and ADO has no way of decrypting it. > XL2000: "Could Not Decrypt File" Error with Password Protected File > http://support.microsoft.com/?KBID=211378 > I guess the only way to get at this is running application.excel and > using a password from there > to get at the data. > So you would need a copy of excel on the running macine. > Gustav Brock wrote: >>Hi all >> >>If you try to link/attach an Excel range where the workbook is >>password protected (Save as .. with password), you'll receive the >>error above. >>The wizard can not accept a password. >> >>I tried, in code, to modify the connect string with >> >> PWD=mypassword; >> >>so it becomes >> >> Excel 5.0;HDR=YES;IMEX=2;PWD=mypassword;DATABASE=c:\temp\Test.xls >> >>but that is not recognized when I try to do a RefreshLink - same >>error. >> >>Is this possible?