如何从路径中提取文件名? [英] How to extract file name from path?

问题描述

如何在 VBA 中从 C:\Documents\myfile.pdf 中提取文件名 myfile.pdf?

How do I extract the filename myfile.pdf from C:\Documents\myfile.pdf in VBA?

推荐答案

这取自 snippets.dzone.com:

Function GetFilenameFromPath(ByVal strPath As String) As String
' Returns the rightmost characters of a string upto but not including the rightmost '\'
' e.g. 'c:\winnt\win.ini' returns 'win.ini'

    If Right$(strPath, 1) <> "\" And Len(strPath) > 0 Then
        GetFilenameFromPath = GetFilenameFromPath(Left$(strPath, Len(strPath) - 1)) + Right$(strPath, 1)
    End If
End Function

这篇关于如何从路径中提取文件名?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！