I need to create a "save file" command in my macro which allows the file to save to the current directory to prevent "run errors" if the end user has a different directory tree.
E.g. I may be using a default c:\ directory, but the spreadsheet user may be on say h:\ directory on a network. The save command needs to be able to save to the open directory.
Any advice appreciated!
Bookmarks