Skip to main content

How to extract file name from FullPath string using VBA

Extract Name of the File from Path / Fullname using VBA

There are many methods to extract the filename from a given string. You can use FileSystemObject's function GetFileName or can use Arrays to get the last element of the array split by path separator

Here we use even simpler functions like Dir and InStrRev to achieve the same

Dir function will retrieve the name only if the file exists:


strFilePath = "C:\Users\comp\Documents\sample.xlsx"

sFileName = Dir(strFilePath)


If the file doesn't exist, Dir function will return an empty string. The following would be a better option


strFilePath = "C:\Users\comp\Documents\sample.xlsx"

sFileName = Mid(strFilePath, InStrRev(strFilePath, "\") + 1, Len(strFilePath))


Try it out and post the options you use

Facebook

Facebook Recommendations

Followers


Web Designing In Karachi



Haroof.com


Politics blogs

My Zimbio

Email Subscribe

Enter your email address:

Watch online Live TV

Popular posts from this blog

Awaz Public Ki {Elections in Pakistan}

Q: As all the major parties are taking part in the elections, what future scenario do you foresee? Explain: The general elections are going to be held on January 8, 2008. All major political parties except two or three are participating in the elections. Among the major parties, contesting the elections, are Pakistan Muslim League (Q), Pakistan Muslim League (N), Pakistan People’s Party, Jamiat Ulma-e-Islam (F), Muttehadda Qaumi Movement, Pakistan Muslim League (Functional). As all the major parties are taking part in the elections, what future scenario do you foresee? Awaz Public Ki the elections will lead to a confused scenario if the establishment tried to manipulate the polls as it did in the past elections.they must avoid to engineer the elections, which will prove disasterous for the country. tanveer hussaini [Karachi]Posted on 26, Dec 2007 --> As far as future of polls.. the political system has been set on flames unfortunately.. I would like to say that for any successful n...

Microsoft SQL Server is the best among Microsoft’s Products

Microsoft has come up with Microsoft SQL server to cater to the needs of the computer operators, who want to provide advanced facilities on the other computers among networking process. The Microsoft SQL Server 2005 Express Edition is a newly developed product that is easy-to-use, lightweight, and enables the person to work more efficiently than before. The new SQL Server Express Edition with advanced facilities is perfect for use as a backend to a small, multi-user application that requires more superior features like Web reporting or full-text search. This Microsoft sql server standard express edition includes influential features as in SQL Server Management Studio Express that is capable of managing a database very easily. Along with this, it also creates and deploys database code such as stored procedures, user-defined types, functions, and user-defined aggregates from directly within the Visual Studio development environment. All these features tend to help you in enjoying your ...

Matric General Group Result SECONDARY SCHOOL CERTIFICATE (S. S. C.) PART - II CLASS - X - 2010 (www.apnieyesp.com )

PASSED THE SECONDARY SCHOOL CERTIFICATE (S. S. C.) PART - II CLASS - X) ANNUAL EXAMINATION, 2010. ERRORS AND OMISSIONS EXCEPTED, CANDIDATES BEARING THE FOLLOWING ROLL NUMBERS ARE DECLARED TO HAVE PASSED THE SECONDARY SCHOOL CERTIFICATE (S. S. C.) PART - II CLASS - X) ANNUAL EXAMINATION, 2010. ------------------------------------------------- GENERAL GROUP (REG&PVT) --- GRADE..'A-ONE' ---- ----------------------- ( CANDIDATES SECURING TOTAL MARKS 680 AND ABOVE) MARKS SECURED BY THE CANDIDATES OUT OF TOTAL MARKS OF 850 ARE MENTIONED AGAINST EACH ROLL NUMBER IN BRACKET --------------------------------------------------- 601086 (689) XXX (XXX) XXX (XXX) XXX (XXX) XXX (XXX) XXX (XXX) 601327 (681) 363 (684) 364 (719) 407 (685) 664 (682) 788 (687) 601836 (692) 882 (683) XXX (XXX) XXX (XXX) XXX (XXX) XXX (XXX) 602315 (723) 316 (715) 320 (712) 321 (739) 325 (686) 326 (702) 602327 (683) 329 (70...

Labels

Show more