File Exists

[Pflugs]

I am having a macro search for a file on the desktop under "C:\Documents and
Settings\All Users\Desktop\" using "result = Object.FileExists(file_name)".
I know the file exists, but the result is always false. Is there something
wrong with FileExists, or should I do something different?

Thanks,

Matthew

[dominicb]

Good morning Pflugs

This code will return true or false (displayed in a msgbox) when checking for a file.

Sub DoesFileExist()
Set MyFile = CreateObject("Scripting.FileSystemObject")
MsgBox MyFile.FileExists("c:\book1.xls")
End Sub

HTH

DominicB

[William Benson]

You say you know it exists ... I assume because you see it on your
desktop... Are you sure it is in All Users\Desktop and not rather in your
own UserName\Desktop? They are not the same path, even though files in
either will show on (your) desktop.

Bill

"Pflugs" <[email protected]> wrote in message
news:[email protected]...
>I am having a macro search for a file on the desktop under "C:\Documents
>and
> Settings\All Users\Desktop\" using "result =
> Object.FileExists(file_name)".
> I know the file exists, but the result is always false. Is there
> something
> wrong with FileExists, or should I do something different?
>
> Thanks,
>
> Matthew