Do you think that its possible that I can programme the macro to change the name of the file automatically so that I dont have to type a new file name on the save as box, but at the same time not replacing the previous saved file?
It did work, thanks. But what i realywant to do is save the file with a new name everytime i run that macro... eg: everytime i run the macro it should save the file as "Pedro Week 1", the folowing week i run the macro again but it needs to be saved as "Pedro Week 2" so it does not replaces or asks me if i want to replace the first one and so on. Thanks
I have a spreadsheet with a generic filename which resides in My Documents. How could I force the sheet, when modified, to autosave with a new filename (generated from a cell entry within the spreadsheet) to a new folder, say, My Modified Sheets. I.e. All modified sheets (renamed according to an entry made on the sheet in a specific cell) being saved in one folder but a different folder from the folder where the generic sheet resides. Hope that's clear and thanks in anticipation.