If you want your Excel app to default to a specific directory when opening or saving files, see Changing the Current Directory. Be sure to read the comments.
I have a slightly different situation. I want my app to open to a specific directory that will give me easy access to sub directories. [...] Read More...