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