Posted to microsoft.public.excel.programming

Nirmal Singh[_2_] Nirmal Singh[_2_] is offline

external usenet poster

Posts: 9

Working with application path

Given the following path:

s = Excel.ActiveWorkbook.Path

how can I find the parent folder 3 levels up?

Eg if s = p:\paydata\hrimp\library\monthlystats\2005\12\Chie fExec

i want to be able to return p:\paydata\hrimp\library\monthlystats

I could do it by searching for the \ characters from the end of the
string, but it is there any easier way to do this?

Nirmal Singh

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
Smart Application.Path	helmekki[_95_]	Excel Programming	0	October 13th 05 01:19 PM
How do I set a default path when using Application.GetOpenFilename	pkohler[_7_]	Excel Programming	2	July 13th 04 07:17 PM
set path for Application.Run	zSplash	Excel Programming	1	January 28th 04 09:41 PM
Application.Path in Excel 2k and 2002	Simon[_12_]	Excel Programming	1	November 12th 03 05:51 PM
Application.Path	Simon Davies	Excel Programming	1	November 12th 03 04:52 PM

All times are GMT +1. The time now is 08:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us