Thanks Tom,

Will have to find another solution then.
FD

"Tom Ogilvy" wrote in message
...
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