Not sure it applies to your particular situation, but I think there is an
issue with files like pagefile.sys

RBS


"BigJimmer" wrote in message
...
I have the following code...

Dim fName As String
dim DestPath as string

DestPath = ThisWorkbook.Path & "\"
fName = Dir(DestPath & "*.*")
Do Until fName = vbNullString

'additional logic here

fName = Dir
Loop

I get error 5 Invalid procedure call or argument on the line fname = Dir
and
don't understand why.

I am using Excel 2000.

Thanks!