Re: Filename coding with date

Tech-Archive recommends: Fix windows errors by optimizing your registry

Activeworkbook.SaveAs Filename:=Activeworkbook.Path & "\testfile_" &
Format(Date,"yyyymmdd") & .xls"

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"DeanT" <DeanT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F11C1AD8-DECF-4332-9F33-670FA4F547B7@xxxxxxxxxxxxxxxx
At the end of my macros, I want to save my workbook to another folder with
another name. I want to save the file AS:

C:/Mydata/testfile_yyyymmdd,xls where yyyymmdd is the current date.

How do I code this in the macro.?

Thanks for your help.

Dean


.

Relevant Pages

  • Re: Use Sort method for 2002/2003 in 2000.
    ... Bob Phillips ... in the email address with gmail if mailing direct) ... Again in Excel 2000 I get the msg that the variable xlSortTextAsNumbers ...
    (microsoft.public.excel.programming)
  • Re: any UDF for sum or rounded product
    ... to gmail if mailing direct) ... number of factors and decimals - like a generic/productive formula. ... "Bob Phillips" wrote: ...
    (microsoft.public.excel.programming)
  • Re: AVERAGE function
    ... Bob Phillips ... (replace somewhere in email address with gmail if mailing direct) ... After posting, I went out for lunch (and a nice drop of Old Speckled ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Counting Values Across Columns
    ... to gmail if mailing direct) ... Bob Phillips Wrote:- ...
    (microsoft.public.excel.setup)
  • Re: Unique entry count
    ... Bob Phillips ... (replace somewhere in email address with gmail if mailing direct) ... type an entry in A1. ...
    (microsoft.public.excel.misc)