Run-time error '1004':File not found

Heya everyone,

I have been having problems with a script and hoped that someone could help.

The script below scans through a specified folder on a network and scans every xls file inside that folder for a value. When it finds the spreadsheet which contains that value (a policy number) it outputs some of the data from the matching file and also provides a link to the sheet in question.

It worked perfectly until I saved, exited and re-opened the file and now I am getting a 1004 run-time error every time I try and execute the script.

I cant for the life of me work out a cause.

More baffling, the wording of the error says that the file 'R:\Dir\Cancellations.xls' could not be found.

At no point is a file called 'Cancellations.xls' specified. Why has the script decided to search for a file called 'Cancellations'?

Baffling,

Thanks in advance,

DomV

Please Login or Register  to view this content.

And the line that the debugger flags is:

Please Login or Register  to view this content.

X-post here BTW.