Manipulating filenames in Excel or Access, or VB/A

Development, VBA

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

  • GetFileExt(), ChangeFileExt()
  • StripFileName(), StripFilePath() and StripFileExt()

Please see the code comments for more details and specifics on how to use them.

 

Comments on this entry are closed.