How to fill up excel names based on filename

Vote count:

0

I would like to ask if there is an excel macro or vba to automatically get the file name e.g. D01Q12013 and then add three new columns(District, Quarter, Year) to a table with existing data in the first thirteen columns, and populate the three new columns based on the filename (District - 01, Quarter - 1, Year - 2013)?

asked 56 secs ago

user3755412

1