get folder name

[matrixindicator]

Hoy, in .php you can get the folder name out of an URL.

$dir = opendir("support/desktop/documents/general"); 

// loop through the directory contents 
while($file = readdir($dir)) { 
    //output contents to the browser 
    echo $file . "<br>"; 
}

This is a VBA access forum. I need to get something similar in VBA to get the name of a folder, are there some methods or ways to do so ?

 

[HarleyQuinn]

I'd have a look at using the FileSystemObject (you'll need a reference to MicroSoft Scripting Runtime).

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Remou]

Yes. You can use Dir.

Thedir = dir("support/desktop/documents/general")
' loop through the directory contents 
Do While TheDir<>""
  DirList=DirList & vbcrlf & TheDir
  Thedir = dir 
  'output contents 
  Debug.Print DirList
Loop