Movefile with variable file names

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!

 Accepted Answer

Adam
Adam on 20 Mar 2017
Edited: Adam on 20 Mar 2017
Use the function syntax of movefile to use a variable...
movefile( source, destination );

More Answers (0)

Categories

Find more on Files and Folders in Help Center and File Exchange

Asked:

on 20 Mar 2017

Commented:

on 20 Mar 2017

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!