Saving A Workbook With A Varaiable File Name

[Owen.OSullivan]

Hi,

Once every day at a specific time, I am opening an excel workbook as a scheduled task and then running a macro activated with Autpen. I want to save the file as part of the macro but want the name to change to indicate the date that the workbook was opened and the macro activated.

For example, I want the workbook to be saved as "Daily Carriage Analysis 05-04-2011" when saved on the fifth of April 2011 and as "Daily Carriage Analysis 06-04-2011" when saved on the sixth of April 2011 etc.

I can build the file name (including the folder path) in a cell in the work book as part of the macro but just cannot use that built name to save the file.

Is this possible?

Any help, much appreciated.

Many thanks.

 

[Trevor G]

Owen,

Welcome to the forum,

If you hold the date in a cell or refer to it at the time of saving it is possible, but you might need to format it at the time of saving then include the file extension as well otherwise it doesn't like it. I haven't tested this but give it a go.

Sub saveMe()
ActiveWorkbook.SaveAs Range("B2").Value & Format(Date, "dd mm yyyy") & ".xls"
End Sub

 

[Owen.OSullivan]

Many thanks Trevor, I will give that a go and see how I get on. Will let you know.

 

[texasalynn]

Welcome to MrExcel board....


Public Sub SaveAsA1()</PRE>
ThisFile = Range("A1").Value<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o></PRE>
ActiveWorkbook.SaveAs Filename:=ThisFile<o></o></PRE>
End Sub<o></o></PRE>

 

[Owen.OSullivan]

Many thanks Texasalynn. The solution offered by Trevor G has worked. I will try this as well.