CurDir(Drive)
Returns the current folder on the given drive.
Drive is a text string specifying the drive letter.
If Drive is not specified, the current drive will be used.
See also: ChDir, ChDrive, MkDir, RmDir
Example:
Sub Main
MsgBox "The current folder is: " & CurDir()
End Sub