Movefile with variable file names

10 views (last 30 days)
gosox2017
gosox2017 on 20 Mar 2017
Commented: gosox2017 on 20 Mar 2017
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

Community Treasure Hunt

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

Start Hunting!