Saving Excel File with Name and Date Details

Sponsor

Excel Tips Saving Excel File with Name and Date Details [Q]
I need excel tips to save Microsoft excel file I am working on (template) with the name of
the file and the date?

ex. “filename - 2008-10-29.xls”

also, if the name is duplicated, add a number to the end numerically

ex. “filename - 2008-10-29-01.xls”

Excel Tips Saving Excel File with Name and Date Details [A]

You can follow this excel tips to creates microsoft excel files in the
following format if already in the same path

filename - 2008-10-29.xls
filename - 2008-10-29(1).xls
filename - 2008-10-29(2).xls

etc…..

Dim myPath As String, myFile As String, myExt As String, mySerial As
String

mySerial = “”
myPath = “C:\Test\”
myFile = “filename” & ” - ” & Format(Date,”YYYY-MM-DD”)
myExt = “.xls”

‘ create output using sequence 1 to n if file already exists
If Len(Dir(myPath & myFile & mySerial & myExt)) > 0 Then

Do While Len(Dir(myPath & myFile & mySerial & myExt)) > 0
mySerial = “(” & Val(Mid(mySerial, 2)) + 1 & “)”
Loop

End If

ActiveWorkbook.SaveAs Filename:=myPath & myFile & mySerial & myExt

Rate This Tips:

Incoming excel search terms

excel file save date formula,save excel file with date,excel file save date,name of day excel date 2008,excel file date,excel file name,excel save date,save excel as date,append date to filename in excel macro,dim mypath as string myfile as string myext as string myserial as string,excel file details,excel file name with date,excel how to automatically save a file with date in name,excel save date formula,excel save file with date,excel vba file date,excel vba save file with date,save file date time seconds vba,vba open filename previous day date,,add time to filename when saving file,auto append filename excel with date,automatic date excel file name,automatic naming of excel files,automatically include date in excel file name,date created excel,details about a file in excel,details of excel sheet,excel date created,excel date of file,excel file date function,excel macro auto save different filename,excel macro to add date to filename,excel macros save as days date,excel save filename date,excel thisworkbook saveas mypath & myfile,excel vba add date time to filename,excel vba auto saveas filename date,excel vba filename date,excel vba saving a file as the name in a cell,formula for automatic date in excel,how to add the date to the name of an excel file when saving,how to put a date in excel file name,how to save a excel file using a filename based on date?,naming excel files,save an excel file under an automatic name,save file previous business day excel macro,saving a spreadsheet and appending the date to the filename,saving excel files,saving excel files with date

Related Excel Tips

• Transfer Data Between Workbooks (0)
• Resize Range for Column in Workbook (1)
• Remove Hyperlinks in Excel (2)
• Problem When Inserting Image or Picture Box (1)
• How To Transpose Column into Rows (0)
• How to Draw Lines on User Form (0)
• Using Relative Excel Spreadsheet References in Vba macro (2)

Comments

• Archives

  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009

• Categories

  • Excel Vba
  • Excel Tips
  • Excel Formulas
  • Excel Date Functions
  • Excel Spreadsheet
  • Excel Worksheet
  • Excel Miscellaneous

• Partners

  • Search Xls
  • Xls Files

• Latest Excel Tips

  • Search-Engine-Excel.Com - The Helpful One for You
  • Switch Minutes to Seconds in Excel
  • Excel Polynomial Trendline
  • Sending Multiple Personalized Email from Excel
  • Excel Sumif Multiple Criteria
  • Remove Hyperlinks in Excel
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria
  • Streamlining Macro Created by Macros Recorder
  • Copying Cells Which Include Conditional Formatting in Worksheet
  • How to Draw Lines on User Form

• Most Viewed Excel Tips

  • How to Divide a Number With “Less Than” Sign? - 62,334 views
  • Macro VBA to Remove Characters in String of Text - 32,023 views
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria - 30,548 views
  • Date Calculation Start Date Minus Year, Month and Days - 27,196 views
  • Excel Sumif Multiple Criteria - 21,397 views
  • Embedded Chart on Worksheet Using Excel Vba - 20,106 views
  • Protect Range of Rows and Columns in Worksheet with Macro - 20,074 views

• Best Excel Tips

  • Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
  • How to Remove Excel Vba Macro Button (5.00 out of 5)
  • Remove Hyperlinks in Excel (5.00 out of 5)
  • Delete Worksheet (5.00 out of 5)
  • Copy from Worksheet (5.00 out of 5)
  • How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
  • Unprotect Worksheet Password (5.00 out of 5)

• Excel Tags

  Excel Vba vba excel xcel vba vba xcel Excel Tips Excel Formulas excel formula xcel formulas xcel tips excel vba add worksheet excel vba create new workbook excel worksheet formulas xcel formula Excel Worksheet microsoft excel tips excel vba date functions excel date function Excel Spreadsheet excel vba active worksheet excel vba worksheet change excel vba worksheet name excel vba worksheet_change excel vba delete worksheet excel vba select worksheet excel vba clear worksheet excel vba copy worksheet excel vba macro add new worksheet how to add new worksheet excel miscellanous