• Home
 · 
• Files/File Controls/Input/Output
 · 
• The easyest way to get the filename from a full path(1 row) and the path (2 rows)

The easyest way to get the filename from a full path(1 row) and the path (2 rows)

The easyest way to get the filename from a full path(1 row) and the path (2 rows)

Rate The easyest way to get the filename from a full path(1 row) and the path (2 rows)

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

PathAndFilename = "C:\windows\command.com"
File_Name = Dir(PathAndFilename) 

'and retrieving the path:

PathAndFilename = "C:\windows\command.com"
File_Name = Dir(PathAndFilename) 
Path = Left(File_Name, Len(PathAndFilename) - Len(File_Name))


'Dir("C:\Windows\command.com") is possible too (1 row)

'File_Name = Dir("C:\Windows\command.com")
'Path = Left(File_Name, Len("C:\Windows\command.com") - Len(File_Name)) (2 rows)