Description

Validates a file name for character set and optionally for uniqueness in a file folder.

Return Type

A String value.   A String with value a valid file name (compliant with VFAT, NTFS, FAT32, Joelett)
Failure Returns vbNullString.

Failure conditions:
* sNewName does Not have any valid characters.

Syntax

object.MakeFileName (sNewName, [sPath])

The MakeFileName Method syntax has these parts:

PartDescription
objectAn expression evaluating to an object of type McDataManager.
sNewNameRequired. A String value. The Proposed name of the new file.
sPathOptional. A String value. The Proposed file path of the new file. When this is specified the path is checked for existence and the return value will be modified when file with the given name already exists.

Remarks

* sPath is given but does Not exist.