relative path How is

need to open some  data books  

but want to use the relative path

not the full path

but is not opening why ??
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
aikimarkCommented:
The key word is "relative".  What is your current/starting folder?

If I'm in folder B, then the relative path to C would be: ..\C
0
 
aikimarkCommented:
We need more details
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
I have some files an folder

1- folder A ( folder A is in C drive)

then

2- inside folder A  

have many files B, C ,D



 want the relativa path no the full path
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
aikimark Thanks for the fast reponse

need create an button to open   file inside folder B

folder b is inside folder A


aaaaaaaa.PNG

folder A is inside drive C


need buton to open file HHH  with the relative path
0
 
aikimarkCommented:
No. I'm no closer to understanding your relative path problem than I was when I first read the question.

The path to HHH is: C:\A\B\HHH
No relative pathing is necessary.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
aikimark

Thnkas  

i need it because i can change the folder A location  in any time
0
 
Martin LissOlder than dirtCommented:
Do you mean this? It allows you to select any workbook that's in your current path. If you want to you can change this line

fDialog.InitialFileName = ThisWorkbook.Path

Open in new window


to something like

fDialog.InitialFileName = "C:\folderA\folderB"

Open in new window


where folderA is the main folder and folderB is a subfolder inside that folder.
29076816.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin  

my question is to not use the C drive letter

because if i change the location  i will have to make a lot of changes to the buttons
0
 
Martin LissOlder than dirtCommented:
OK then it currently will open the folder where your main workbook is. Isn't that what you want?
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin that a great one

it will help !!
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Best Experts !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.