Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

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 ??
Microsoft ApplicationsMicrosoft OfficeVBAMicrosoft Excel

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
aikimark

We need more details
ADRIANA P

ASKER
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
ASKER CERTIFIED SOLUTION
aikimark

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
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
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
aikimark

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.
ADRIANA P

ASKER
aikimark

Thnkas  

i need it because i can change the folder A location  in any time
SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
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
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

OK then it currently will open the folder where your main workbook is. Isn't that what you want?
ADRIANA P

ASKER
Martin that a great one

it will help !!
ADRIANA P

ASKER
Best Experts !
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck