the workbook is saved in an encrypted format. unprotecting it would require
opening it and saving it as an unencrypted file.

--
Regards,
Tom Ogilvy

"FrigidDigit" wrote in message
...
Rowan,

Your suggestion about the worksheet protection was on the money, can I
unprotect the workbook via VBA without opening it?

Thanks for all your help.

FD

"Rowan Drummond" wrote in message
...
No idea on that one I am afraid.

Some guesses: check that you can open the file normally in excel (it's
not
corrupted) and that it is not password protected.

Good luck
Rowan

FrigidDigit wrote:
Rowan,

Sorry one more question,

I have added another excel workbook to one of the folders i am looping
through and suddenly when trying to extract cell values from that file,
VBA returns a runtime error'-2147467259 (800004005) could not decrypt
file error.

Any idea what is causing this?

Thanks again

FD