9
9119
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!
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!