VBA filename Archives - Francesco Foti's weblog

Do you often need to manipulate filenames in VBA ?Here’s a small set of very useful functions that I regularly use: GetFileExt

Public Function GetFileExt(ByRef psFilename As String) As String

1	Public Function GetFileExt(ByRef psFilename As String) As String

Get the file extension part of a filename, without the leading dot (“.”). Example (type in immediate window):

  ?GetFileExt("test.txt")
  txt
  ?GetFileExt("https://www.example.com/index.html")
  html

?GetFileExt("test.txt")

txt

?GetFileExt("https://www.example.com/index.html")

html

StripFileExt

Public Function StripFileExt(ByRef psFilename As String) As String

1	Public Function StripFileExt(ByRef psFilename As String) As String

Tag: VBA filename