Visual Basic for Applications Reference
CurDir Function
Returns a Variant (String) representing the current path.
Syntax
CurDir[(drive)]
The optional driveargument is a string expression that specifies an existing drive. If no drive is specified or if drive is a zero-length string (""), CurDir returns the path for the current drive.