Relative path
 

How do I specify a relative path in vba, to assign to a variable?

Relative path
 

Relative to what?

Maybe...

Dim myPath as string
dim myPathParent as string

mypath = "C:\my documents\excel\test"
mypathparent = mypath & "\.."

Watch out for that backslash. Include it only one location.



Perico wrote:

How do I specify a relative path in vba, to assign to a variable?

--

Dave Peterson

Relative path
 

It isn't clear what you are trying to accomplish, but you can use "..\" to
get a parent folder. E.g.,

ChDir "C:\Test\Sub1\SubSub1"
Debug.Print Dir("..\..\Sub1\Test.txt", vbNormal)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Perico" wrote in message
...
How do I specify a relative path in vba, to assign to a variable?