Gustav Brock
gustav at cactus.dk
Thu May 6 11:02:57 CDT 2004
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? /gustav