i have to save about 1000 different csv files and every time i click file save as, it goes to some default directory.
is there anyway it can default to remember the directory that i saved the last file into?
You can try adding registry setting for Excel.
This should make "Save As" use the same folder where the file was opened in. If you set the value to 1, it will use Default folder when using "Save As"