Determining a default directory

I have been trying to figure this out for days and it is driving me nuts because it should be super simple. I have a code that saves cells to a text file and that code works perfectly. However, I would like to alter the code to start at a certain location when the Save As window pops up. Right now it defaults to where the workbook is saved. Is this possible? I'm on a Excel 2011 for Mac.

Here is my current code:

Please Login or Register  to view this content.

Any and all help is greatly appreciated! Thank you!

I have looked into that and nothing I tried worked. Where should I be putting that code in my current code? I cannot for the life of me get it to work.

Thanks!!