<div>
dim f as string, filePath as string<br />
<br />
f=&quot;C:\Documents and Settings\w6068c\My Documents\My Pictures\Natan.jpg&quot;<br />
<br />
filePath=left(f,instrrev(f<wbr />,&quot;\&quot;)-1)
</div>


dim f as string, filePath as string

f="C:\Documents and Settings\w6068c\My Documents\My Pictures\Natan.jpg"

filePath=left(f,instrrev(f,"\")-1)

<div>
what about the folder path and the extension?
</div>


what about the folder path and the extension?

<div>
<div class="content wysiwyg-content">
Can someone help me with some string manipulation code on a file path using VBA.<br />
<br />
Here is an example (please try and give me code that will pertain to any given file path)<br />
<br />
&quot;C:\Documents and Settings\w6068c\My Documents\My Pictures\Natan.jpg&quot;<br />
<br />
-I need to extract the path of the folder (i.e. &quot;C:\Documents and Settings\w6068c\My Documents\My Pictures&quot;)<br />
-The file itself &quot;Natan.jpg&quot;<br />
-And the extension &quot;.jpg&quot;<br />
<br />
Thanks In Advance
</div>
</div>


Can someone help me with some string manipulation code on a file path using VBA.

Here is an example (please try and give me code that will pertain to any given file path)

"C:\Documents and Settings\w6068c\My Documents\My Pictures\Natan.jpg"

-I need to extract the path of the folder (i.e. "C:\Documents and Settings\w6068c\My Documents\My Pictures")
-The file itself "Natan.jpg"
-And the extension ".jpg"

Thanks In Advance

String Manipulation on a file path VBA

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.