I would like to use a macro to save a spread sheet in a specific folder with the date as the file name. I have come to the conclusion that there is no way to do this in excel without using code because when the save window opens you are technically out of excel (i think). If anyone can help me this I will be very very greatful.

Thanks

I still haven't found a solution to this problem apart from this one here
http://www.dailydoseofexcel.com/archives/2004/04/21/save-file-with-date

I guess if you know how to use vba this may be all you need so could someone explain to me how exactly I should use this in the vba editor in excel. I am pretty clueless as you can probably tell. Any help you can give will be much appreciated.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.