I have a scheduled task that opens excel and automatically runs a macro. The macro gathers lots of text files and puts them into one excel file, then places a 'saved as' copy of the excel file in another folder, using the date as the file name.

This is working as I want it to, however the problem is that each time it's also saving the original 'template' file. So each day I run it, it's keeping each days worth, for example the file for today also has all of last weeks data in it.

Is there any way around this? I'd like to either not save the data to the original file so it's clean each day i run it, or, alternatively, save it into a new tab each day.

The other problem i'm having is when this file runs automatically each day, it'll open through the scheduled task but then it'll stop with a message that says 'Security Warning = Data connnections have been disabled ENABLE CONTENT'. How do I stop this message from appearing each time? I thought i'd enabled macros via the options but it doesn't seem to have helped. Could this be a network/group policy thing that I would need to get enabled at a higher level?