Home » Forums » Open Source Learning Center » Question and Answer

GET date from filename

Submitted by johnD on 13 November, 2013 - 21:39

Hi,
I have a file as filenamex - filenamey-date
how to write vba code to get date from filename in column A till end of the row.
please help

‹ Excel 2010 - Userform - Updating data on same row on datasheet if same unique number Formula for caluculating empty and text ›
»

You shouldn't need VBA for

Submitted by chris on 20 January, 2014 - 18:42.

You shouldn't need VBA for this. To get the current workbook filename you can use the formula =CELL("filename"). Depending on your date format, you should be able to use something like =RIGHT(CELL("filename"),10) to take the last 10 characters from the filename.

Chris

»