@skmguy: "I was wondering if it was possible to change the default file path in the 
save as text.  I'm using a macro to copy data from one sheet to the next and 
then save that sheet with the dates a user selected for the copied data.  The 
save always defaults to the directory the file is in.  Can I change that 
property?  I've been able to edit the default name.  Thanks for you help!"
    @AlanMoseley: "Within your macro (you will have to edit it using the VBA editor) there will 
be a line such as:-
MyFileName=GetSaveAsFilename()
Change this to something like:-
MyFileName=GetSaveAsFilename("C:\MyDirectory")
Bob should be your uncle.  Hope it helps.
Alan Moseley IT Consultancy
<url>
<quote>"
{'source': 'USENET', 'other_information': '{"reply_count": 1, "forum_name": "microsoft.public.office.developer.vba.20140605.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}