saving a file with a date
 

Hi. I am looking how to save a file with a date in it from code. In
other words I have a macro that I use and at the end I want to save
the file "workbook 1" as "workbook 1 10-07-2009" with 10-07-2009
representing whatever date I am saving it on. I cannot find that
information in the help file. Can someone enlighte me please?

Thanks

saving a file with a date
 

Hi,
This creates the filename string and holds is in a variable called fnam

fnam = "Workbook 1 " & Format(Date, "mm-dd-yyyy")

Mike

"pat67" wrote:

Hi. I am looking how to save a file with a date in it from code. In
other words I have a macro that I use and at the end I want to save
the file "workbook 1" as "workbook 1 10-07-2009" with 10-07-2009
representing whatever date I am saving it on. I cannot find that
information in the help file. Can someone enlighte me please?

Thanks

saving a file with a date
 

On Oct 8, 2:34*pm, Mike H wrote:
Hi,
This creates the filename string and holds is in a variable called fnam

fnam = "Workbook 1 " & Format(Date, "mm-dd-yyyy")

Mike



"pat67" wrote:
Hi. I am looking how to save a file with a date in it from code. In
other words I have a macro that I use and at the end I want to save
the file "workbook 1" as "workbook 1 10-07-2009" with 10-07-2009
representing whatever date I am saving it on. I cannot find that
information in the help file. Can someone enlighte me please?

Thanks- Hide quoted text -

- Show quoted text -

Great. Thanks

saving a file with a date
 

Your welcome

"pat67" wrote:

On Oct 8, 2:34 pm, Mike H wrote:
Hi,
This creates the filename string and holds is in a variable called fnam

fnam = "Workbook 1 " & Format(Date, "mm-dd-yyyy")

Mike



"pat67" wrote:
Hi. I am looking how to save a file with a date in it from code. In
other words I have a macro that I use and at the end I want to save
the file "workbook 1" as "workbook 1 10-07-2009" with 10-07-2009
representing whatever date I am saving it on. I cannot find that
information in the help file. Can someone enlighte me please?

Thanks- Hide quoted text -

- Show quoted text -

Great. Thanks