FileExists not working...

[dhamal1]

Hi,
I need to check if .doc file exist in a folder called My Documents but it seems to be not working. dont know what am i going wrong:
Set filesys = CreateObject("Scripting.FileSystemObject")
Set NewFolder = filesys.GetFolder("C:\My Documents")
If filesys.FileExists(NewFolder & "\") Then

msg = " exists."

Else

msg = " doesn't exist."

 

[PScottC]

1) "NewFolder" is a Folder Object Reference
2) "\" isn't a file name.

The FileExists method of the File System Object expects it's input to be a string containing the file name with or without the full path.

Use:

If filesys.FileExists([red]"C:\My Documents\Myfile.doc"[/red]) Then


PSC

Governments and corporations need people like you and me. We are samurai. The keyboard cowboys. And all those other people out there who have no idea what's going on are the cattle. Mooo! --Mr. The Plague, from the movie "Hackers

 

[dm4ever]

...or use FolderExists if you're testing for the existance of a folder.

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid

 

[dhamal1]

i got the solution. I can not use fileexists becaseu i am checking if there is file in the folder or not as i dont know the file name. Solution is: for loop to count file in the folder.

 

[dm4ever]

or newfolder.files.count

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid