I have created a macro that creates/saves a text file. The macro will
run on various people's computers and need to create/save the file in
directory that the macro file is located in. By default Excel saves
the file in the directory Excel has been told to put files in.
How do I cause the macro to save the file to the directory the
spreadsheet containing the macro is in?
jim
Bookmarks