View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon[_21_] Jon[_21_] is offline
external usenet poster
 
Posts: 37
Default Split function to get a relative path

I have a full file path and I want to extract only part of the path
using the VBA split function.

For example, in C:\windows\excel\archives\blah.xls I want to extract
"\excel\archives" only.

I have the C:\windows already in another cell. So basically I just
want to cut off this part as well as the file name to give me my
relative path. Any suggestions?