Macro to save as two files at once

[sudheesh]

Hi,

One of my Daily tasks at work involve preparing time stamp report. I run an SQL Query and get the data I need. Now inorder to present the data to relevant people I copy and paste the data on a template which is named "Promise Data Master" then the second excel file which is called "Hourly Promise Report Master" which takes the data from Promise Data Master and presents it in Tables and charts. What I essentially want to do is to place a Macro in my "Hourly Promise Report Master" which when run will 'Save As' with a time stamp as an normal excel file in a specified location and will also 'save as' the "Promise Data Master" with a time stamp in a different location.

Can this be achieved in a single macro across two files?

If yes please help.

Thanks

Sudheesh