Sets the current drive and directory or folder to the specified path and returns the name of the new directory or folder as text
static int Directory( CString strnewdirectory, LPCTSTR path_text = 0 );
A reference to a string that will contain the desired information if the function succeeds.
Path_text is the drive and directory or folder you want to change to. An empty or null string is treated as a missing argument.
Zero if the function has been called successfully; non-zero if the function could not be called. See Error codes for a list of return values.
See the Microsoft Excel on-line Help for full details about this function.