Posted to microsoft.public.excel.programming

Jon[_21_]

external usenet poster

Posts: 37

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Relative Path to a Folder	Heliocracy	Excel Discussion (Misc queries)	3	October 3rd 07 04:28 PM
how to change absolute path to relative path	hwijgerse	Excel Worksheet Functions	0	November 25th 05 07:18 AM
Absolute vs Relative path	K2H	Excel Discussion (Misc queries)	2	July 28th 05 12:50 PM
Relative path	Giovaz	Excel Programming	3	July 13th 04 02:21 PM
relative path.	Bob Kilmer	Excel Programming	0	September 12th 03 12:25 AM

All times are GMT +1. The time now is 05:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us