Get Directory by using the Dir function : Dir « Forms « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Forms
  3. Dir

Get Directory by using the Dir function

 

Sub DirDemo2()
    MsgBox Dir
End Sub








Related examples in the same category

1.Dir() Returns a string representing the name of a file or directory with specified pattern.
2.Use Dir function to get the file directory
3.Get the file names
4.Validate the file path