Hi Stuart,

Could you find out how to create a normal module and insert a function into
it?
If yes, and the function still doesn't work, make a try with this other one:

Function IsFile(filepath)
Set fs = CreateObject("Scripting.FileSystemObject")
IsFile = fs.FileExists(filepath)
End Function

Regards,
Stefi


€žStuart€� ezt Ã*rta:

Hi Rob,

hmmmm - seems none of the file paths are coming back as true when I
know they exist. I'm getting a message #NAME?.

Can you help?

Thanks

Stuart




Robert Bruce wrote:
Roedd <<Stuart wedi ysgrifennu:

Where should this text be pasted into?

Thanks

Stuart

Put it in a regualr module in the workbook your filenames are in. Then just
enter it as a worksheetfunction in, say, B1 and copy down as far as your
filenames go in column A.

Rob