Be REALLY grateful for some quick advice with this one.....

[Audiojoe]

If I want to set a macro to save a file as a certain date, how do I do it?

At the moment, the macro copies a block of data, pastes it into a template, then I want it to save that template as last week's date. For instance, the file template is called Weekly Report Template, when the macro saves it I need it be saved as:

Weekly Report - 18th-24th February 2002

as that is the period that the report covers. However, of course NEXT week it will have to save it as:

Weekly Report - 25th Feb-3rd March 2002

and so on....

Can anyone help me?

 

[Audiojoe]

Sorry man, I'm just on a deadline that is killing me and I needed some help from you guys

 

[Chris Davison]

Hi Joe,

Don't forget, those times of postings are local times in central (?) America, so at 07.30 many of our Excel buddies may not be 100% dedicated to a computer. To compound this, us other Brits are probably wasting our time doing things for our Bosses in the office so might not be able to invest as much *immediate* attention to posted problems as we'd ideally like to.

It's sometimes probably just as frustrating for us not to be able to solve posted problems straight away cos "real life" gets in the way - we're all in the same boat mate : MAX problems and MIN time !!

booayaka
Chris