I can’t seem to remember a simple relative directory reference.
This is what I’m trying to do… I have a cell where I used to hard code a directory path to a network directory. (i.e. H:\HMS\Master Files) Then in various Sub Routines I would reference that cell for the path.
What I’d like to do is put in that cell a relative reference to the same directory that the activeworkbook is located. I used this before but I can’t seem to remember or find an example of it. It was pretty elegant one could even use a similar method to look one directory up. I think it looked something like “\\”.
Any idea’s, it harkens back to old DOS/Basic programming but I believe it still works. I didn’t want to use VBA code i.e. “Thisworkbook.path” for I’d have to change it in so many places. I’d rather figure out the above.
Thanks,
Phil