what is the generic symbol for the root directory in visual basic?

Question

how can I indicate the root direcotry in a file path description when writing a visual basic macro?

Answer 1

You can try using the tilda ~ to indicate the current path as

~/mySub/myProgram.exe
this would indicate to use the subdirectory from the current application path

Or you can use the application object and extract what path info you need. This code extracts the root of the current dirve based upon the application path string

Private Sub cmdDir_Click()
Dim appPath, appRoot As String
Dim ay() As String

appPath = Me.Application.Path
ay = Split(appPath, ":")
appRoot = ay(0) & ":\"

End Sub

Answer 2

you should use a function wich shows the root directory
get help from MSDN