devxlogo

Creating Date-based Filenames

Creating Date-based Filenames

Question:
I am using Excel 97 to create macros. I would like to have my macro “save as” and automaticaly create a filename partially from the current date.for example today is october 10 1997,an approporate name for file group “abc” could be…

  • 1010abc.xls
  • oct10abc.xls
  • 101097abc.xls
This macro will run once a day and save that days data in a unique filename.

Answer:
You can use the Format$ function to build your filename. The Format$ function is very flexible, as shown in the following example. If you wanted to build the second filename, oct10abc.xls, you would use the following code:

Dim sFilename As StringsFilename = Format$(Date$, “mmmddabc.xls”)
Look in the Visual Basic help file for more information on the variety of user-defined Format$ parameters.

See also  5 Benefits of Using Time Tracking Software
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist