Forum Discussion
How to copy a file and rename based column contents
It's possible using the Copy command in a Windows command prompt.
Attached is a workbook with the syntax ready to go.
It is not finding the file folder set up on desktop. Is it because we use OneDrive? I created a folder on my desktop to do a practice run named "Test" and copied the address to cell D1 as the example excel sheet indicated.
When I pasted to Command Prompt
U:\>cd C:\Users\pat.myer\OneDrive - A-dec Inc\Desktop\TestU:\>copy No Image.jpg 001.013.01.jpg
The system cannot find the file specified.U:\>copy No Image.jpg 001.015.00.jpg
The system cannot find the file specified.I believe it's the spaces in the file name. You'd have to adjust the syntax to be:
copy "Document Test.txt" 001.txtPatrick2788 Patrick, not sure what you are meaning by: "I believe it's the spaces in the file name. You'd have to adjust the syntax to be:
copy "Document Test.txt" 001.txt"I am pretty new at this stuff and trying to "expand" my knowledge of how to sort and filter different types of data. I attached my updated excel workbook that I used to try run the Windows Command to copy a No-Image jpg to a list part numbers ("No Image,jpg" to "001.001.00.jpg", "No Image.jpg" to "001.002.00.jpg, "No Image,jpg" to "001.003.00.jpg"....) but it failed.
Thank you Patrick. I will review and give it a try.
