Does a file already exist?

[epratt]

I need to check to see if a file exists and notify the user if it does before proceeding with other functions. The path and filename are stored in a variable called NewTiff. Does anyone have code that does this?

 

[EBGreen]

I would use the FileSystemObject. You can search this forum for examples of it's use.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[strongm]

There are a nmber of ways of doing this. For starters investigate the Dir$ command

 

[Swi]

faq222-3657

Swi