Error code - Could not decrypt file

B

Bogdan

Hi there,

I'm running a code using ADO (copying data from 100 closed workbook).
Everything is ok, except one file for which a get the following error:

"Run-time error '-2147467259 (80004005)':
Could not decrypt file"

I pushed Help button, but the help page is empty.

Any ideas for this annoying error?

Many thanks in advance,

Bogdan
 
B

Bogdan

Hi Ron,

I read the article, but somehow I anticipated this potential cause.

Indeed, the file was password protected, but only for write rights. That's
why I made a copy of this file and I cancelled the password, but problem
persists. If I try to open the file, everything seems normal and no password
is required. Moreover, in this collection of 100 files, there are many other
files with the same type of protection, but I didn't have this problem.

What else could be??? (I have Micrsoft Excel 2003).

Bogdan
 
T

Tom Ogilvy

If you go into tools=>Protection, does it offer the option to unprotect the
workbook. If so, I suspect this is the problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update datasource links programmatically 0
Active Content in this file is blocked issue 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
problem opening file thru code 2
ADO from .xls to .xlsm file - "Unrecognized database format" error 4
Uploadin Excel 2003 to Access 2003 error message "Could not decryp 0
"Could not decrypt file." error on non-password protected file 0
E-Mailing Code Error 6

Top