Member Avatar for roryt

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

  • 1 Contributor
  • 1 Reply
  • 156 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by roryt
Member Avatar for roryt

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 meeting, networking, learning, and sharing knowledge.