<div>
Dim intPos As Integer<br />
<br />
intPos = InStrRev(fileLoc, &quot;\&quot;)<br />
MsgBox Left(fileLoc, intPos - 1)
</div>


Dim intPos As Integer

intPos = InStrRev(fileLoc, "\")
MsgBox Left(fileLoc, intPos - 1)

<div>
Thank you Martin, that works Gold :)
</div>


<div>
You're welcome and I'm glad I was able to help.<br />
<br />
Marty - MVP 2009 to 2013
</div>


You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a variable that stores a file path like this<br />
<br />
fileLoc = &quot;C:\Here\There\myFile.xls&quot;<wbr /><br />
<br />
Now what splitting or anything I need to do to parse out the file name out of that string and retrun me only string without the filename like this<br />
<br />
filLoc now becomes &nbsp; &quot;C:\Here\There&quot;<br />
<br />
<br />
what to do in VBA? if I want the strign like this from a full file path...<br />
<br />
Thanks
</div>
</div>


Hello,

I have a variable that stores a file path like this

fileLoc = "C:\Here\There\myFile.xls"

Now what splitting or anything I need to do to parse out the file name out of that string and retrun me only string without the filename like this

filLoc now becomes   "C:\Here\There"


what to do in VBA? if I want the strign like this from a full file path...

Thanks

VBA This - File location but not file

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.