Moving files (excel) from a folder A to B
2 views (last 30 days)
Show older comments
Hi,
I have some excel files that have to be moved after the work is done.
Using movefile, I tried moving the file but didn't work..
filename = 'holdings_today.csv';
movingfrom = '\\C:\Program Files\MATLAB';
destination = '\\C:\Program Files\MATLAB\excels';
movefile(filename , movingfrom , destination )
Is there anything that I miss important here?
Thanks for your help in advance,
Jake
1 Comment
per isakson
on 28 Dec 2016
You missed the left hand side of
[SUCCESS,MESSAGE,MESSAGEID] = movefile(SOURCE,DESTINATION)
which probably will help you understand why it didn't work.
Accepted Answer
Image Analyst
on 28 Dec 2016
Try getting rid of the double backslashes at the start. And while you're at it might as well convert all of them to forward slashes to avoid potential future problems. Windows can understand forward slashes just fine. Trust me.
2 Comments
Image Analyst
on 28 Dec 2016
Jake, you should be more robust like checking if the folder exists already and creating it if it does not exist yet.
movingfrom = 'C:/Program Files/MATLAB';
if ~exist(movingfrom, 'dir')
mkdir(movingfrom);
end
destination = 'C:/Program Files/MATLAB/excels';
if ~exist(destination, 'dir')
% This will throw an error or fail because
% Windows does not allow you to create a folder or file below Program Files.
mkdir(destination);
end
Your folder creation and moving to a folder "C:/Program Files/MATLAB/excels" will fail because Windows does not let you create files or folders under the Program Files folder. You'll have to pick a different folder.
More Answers (0)
See Also
Categories
Find more on Spreadsheets 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!