Get partial string from ActiveWorkBook.Path

[Rick_Stanich]

I tend to stumble when trying to pull certain characters from strings, not sure how to stop and start my search.

Please Login or Register  to view this content.

sWbPath = ActiveWorkbook.Path
Which is:

F:\CNC Mill\#19 CNC CMM\Inspection Reports\SUNSTR\4503124\Results\33162-1\20

The portion of text in Red is what I need from this path for another variable.

sWbPathCust = sWbPath (some method of extracting the string)

This portion of the path will always be the same:

F:\CNC Mill\#19 CNC CMM\Inspection Reports\

The remainder changes for many customers and part numbers.
"SUNSTR\" = Customer and "4503124\" = Part Number
The character length of Customer and Part Number varies for each. The only constants are the two "\" (Back slashes) after "Inspection Reports\".

Any hints, tips and or examples are appreciated.

[DonkeyOte]

I'm sure there's a better method...

Please Login or Register  to view this content.

[Rick_Stanich]

I'm sure there's a better method...

Please Login or Register  to view this content.

I think I understand what you have done.
The first line you change the 6th "\" to a "^"
And the next line you change it back after getting the left length ending at "^"

Is that correct?

Your code works fine. Thank you!

[DonkeyOte]

Yes, exactly... based on your narrative that should work ? (I think)

[Rick_Stanich]

Your code did exactly as I needed.
Again, thanks.