Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Using the date as part of the file name

  Asked By: Bastet    Date: Dec 27    Category: MS Office    Views: 902
  

I am perplexed by how I can take the date and save it as part of the
file name... ie 062408.xls... I want to be able to insert the code to
get the date Now() from my vba program and then save the excel file im
working in with the current date as the file name....

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Aamanee Khan     Answered On: Dec 27

Look at the Format () function

Format (myDate, "mmddyy")

 
Didn't find what you were looking for? Find more on Using the date as part of the file name Or get search suggestion and latest updates.




Tagged: