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