Changing An Absolute Path To A Relative Path

**elgourmet** · 08-03-2010, 04:42 AM

hello

i am running a VBA script which updates cells of all files in a given folder:

Please Login or Register  to view this content.

in A19, i am defining the path: i.e. C:\Documents\Files\Test

however, this is an absolute path. let's say, the document which executes the macro is located in "Files", i just want to write "\Test", instead of entering the whole absolute path. Or let's say i want to update the cells in the folder above, i would like to write "..\"

does anyone have some hints or tips on how to achieve this?
any help would be very very much appreciated!

**Andrew-R** · 08-03-2010, 04:49 AM

The code

Please Login or Register  to view this content.

Will return the file path of the workbook that is executing the code.

**elgourmet** · 08-03-2010, 05:05 AM

thanks!! exactly what i wanted. works like a charm

one more question though. how can i go one folder up?
..\Test works, but ..\ doesnt....

**Andrew-R** · 08-03-2010, 05:11 AM

Add a little function to find the last occurence of a character within a string ...

Please Login or Register  to view this content.

Then use this to find the last back slash in the file path...

Please Login or Register  to view this content.

**elgourmet** · 08-03-2010, 05:21 AM

very cool, thanks a lot!
i just found out that ..\..\ works as well....
but i will still use your code!

Changing An Absolute Path To A Relative Path

LinkBack

Thread Tools

Rate This Thread

Display

Changing An Absolute Path To A Relative Path

Re: Changin An Absolute Path To A Relative Path

Re: Changin An Absolute Path To A Relative Path

Re: Changin An Absolute Path To A Relative Path

Re: Changin An Absolute Path To A Relative Path

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions