Excel CurDir Function (VBA)
-function/curdir-function-vba-code.jpg)
How to use the CurDir Function (VBA)
This Excel tutorial explains how to use the Excel CurDir function with syntax and examples using VBA.
SUMMARY:
The Excel VBA CurDir function returns the current path of a given drive (String).
PURPOSE:
To get the current path.
RETURN VALUE:
The CurDir function returns a string value.
SYNTAX:
CurDir [ (drive) ]
ARGUMENTS:
The CurDir function syntax has the following arguments:
- drive: Optional. The argument 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.
- On the Macintosh, CurDir ignores any drive specified and simply returns the path for the current drive.
REMARKS:
- If "drive" = "", then the current drive is returned.
- If "drive" is left blank, then the current drive is returned.
- You can use the CURDIR$ function to return a String data type instead of a Variant/String data type.
Diffrent way to use the CurDir function using Excel VBA Code...
-function/curdir-function-vba-code-remark1.jpg)
CurDir Function Example (as VBA code)
The CurDir function can only be used in VBA code in Microsoft Excel.The following VBA code shows how the CurDir function used to get the current path.
CurDir ()
In the above VBA code example, CurDir () function would returns the current path "C:\WINDOWS\SYSTEM".
VBA CurDir Function Error:
If you supply the invalid path name to the CurDir function, you will get the error:Run-time error '68': Device unavailable
-function/curdir-function-error-device-unavailable.jpg)