Get the whole path before the last counterslash

		Microsoft Office Forums > Microsoft Word > Word VBA
Get the whole path before the last counterslash

01-13-2024, 09:41 AM

RobiNew

Windows 10 Get the whole path before the last counterslash

Office 2016

Competent Performer

Join Date: Sep 2023

Posts: 231

Get the whole path before the last counterslash

I know how to get the last subfolder in a path (here below), but how do I get the whole path before the last counterslash? Thanks!

Code:

Sub BeforeCounterslash()
Dim StrText As String
StrText = Trim(Split("C:\Sub_1\Sub_2\Sub_3", "\")(3))
MsgBox StrText
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PDF default path	hernans	Word VBA	8	07-02-2018 06:06 PM
Critical path	bijukn1	Project	2	11-04-2016 10:31 AM
Error with UNC path	Troy R	Mail Merge	1	11-11-2015 09:06 AM
Change old path to new path (batch)	NobodysPerfect	Word VBA	2	08-14-2014 10:09 PM
Doc path	cinque8	Word	4	08-10-2012 06:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:34 PM.