Default File Path

[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!

 

[Alan Moseley]

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.