How to extract file name from path?

by

The best way of working with files and directories in VBA for Office 2000/2003 is using the scripting library.

Create a filesystem object and do all operations using that.

Early binding:

Add a reference to Microsoft Scripting Runtime (Tools > References in the IDE).

Dim fso as new FileSystemObject
Dim fileName As String
fileName = fso.GetFileName("c:\any path\file.txt")

Late binding (see comments for more)

With CreateObject("Scripting.FileSystemObject")
    fileName = .GetFileName(FilePath)
    extName = .GetExtensionName(FilePath)
    baseName = .GetBaseName(FilePath)
    parentName = .GetParentFolderName(FilePath)
End With

The FileSystemObject is great. It offers a lot of features such as getting special folders (My documents, etc.), creating, moving, copying, deleting files and directories in an object oriented manner.

More Related Contents:

  1. How to find numbers from a string?
  2. Check if a string contains another string
  3. Split string into array of characters?
  4. Any method equivalent to PadLeft/PadRight?
  5. Implementing String.Format() in VB6
  6. Matching similar but not exact text strings in Excel VBA projects
  7. Build a Comma Delimited String
  8. Excel VBA like operator [closed]
  9. Why does my string not match when reading user input from stdin?
  10. What’s the difference of strings within single or double quotes in groovy?
  11. Difference between text and varchar (character varying)
  12. Find string between two substrings [duplicate]
  13. Is there a function to split a string in PL/SQL?
  14. How to efficiently concatenate strings in go
  15. Split string in Lua?
  16. pass character strings to ggplot2 within a function
  17. Does xslt have split() function?
  18. swift How to remove optional String Character
  19. How to generate all the permutations of a multiset?
  20. Extract part of a string using bash/cut/split
  21. Insert a character at a specific location in a string
  22. Convert R vector to string vector of 1 element [duplicate]
  23. How do you write multiline strings in Go?
  24. Algorithm to find articles with similar text
  25. Is there a function to split a string in Oracle PL/SQL?
  26. Line continuation of strings in Fortran
  27. How to parse string to date in xslt 2.0
  28. Convert slice of string to slice of pointer to string
  29. Is there “\n” equivalent in VBscript?
  30. How to split a string by a string in Scala

Leave a Comment