After an excel file is pulled from a webpage it saves to my downloads. I want to pull this file into a different folder and then run readtable(). My issue is the file has a date in it so the file name changes every day. Is there a way to use a variable filename in a path in a movefile call? ie. d = datetime('today','format','MM-dd-yyyy'); fileName = strcat('Stock List(',char(d),').xls'); movefile user\blah\downloads/(fileName) users\blah\destination
If this doesn't work how can I use readtable with a path to the file. xlsread() messes with the tables formatting. Thanks!
Best Answer