[vba]'If FExist(sPath) Then
If Len(Dir(sPath)) > 0 Then[/vba]Dir() returns a blank string if the file doesn't exist, otherwise it returns the filename (no path) if it does. Saves a few lines of code
[vba]'If FExist(sPath) Then
If Len(Dir(sPath)) > 0 Then[/vba]Dir() returns a blank string if the file doesn't exist, otherwise it returns the filename (no path) if it does. Saves a few lines of code
Matt
Posting Permissions
Reply With Quote