vb6 - How to extract directory from a file path string?

Question

I want to select a path only from a fully qualified name.

For example, C:NewfolderiTDC.mdb is shown in in the text box.

But I want to take only C:Newfolder, removing the iTDC.mdb.

How can skip the file?

Answer 1

Quick and dirty

Dim sPath As String

sPath = "C:NewfolderiTDC.mdb"

sPath = Left(sPath, InStrRev(sPath, ""))