title: How to fill up excel names based on filename
body: <p>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)?</p>