How to copy a file and rename based column contents

Question

I have on C drive a file thats called BlankImage.jpg.

Inside of excel in column A contains a list of parts, is there an automated way that the BlankImage file can be copied and renamed based on the contents of each cell.

Column A

001.001.00

002.001.00

003.001.00

004.001.00

patrick2788 · Answer

PatMyer&nbsp;It's possible using the Copy command in a Windows command prompt.&nbsp;Attached is a workbook with the syntax ready to go.

patmyer · Answer

Patrick2788&nbsp;Thank you Patrick.&nbsp; I will review and give it a try.&nbsp;&nbsp;

patmyer · Answer

Patrick2788&nbsp;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 PromptU:\&gt;cd C:\Users\pat.myer\OneDrive - A-dec Inc\Desktop\TestU:\&gt;copy No Image.jpg 001.013.01.jpgThe system cannot find the file specified.U:\&gt;copy No Image.jpg 001.015.00.jpgThe system cannot find the file specified.

patrick2788 · Answer

PatMyer&nbsp;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

patmyer · Answer

Patrick2788&nbsp;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&nbsp;"Document Test.txt"&nbsp;001.txt"&nbsp;I am pretty new at this stuff and trying to "expand" my knowledge&nbsp;of how to sort and filter different types of data.&nbsp; 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&nbsp;numbers ("No&nbsp; Image,jpg" to "001.001.00.jpg", "No Image.jpg" to "001.002.00.jpg,&nbsp;"No&nbsp; Image,jpg" to "001.003.00.jpg"....) but it failed.&nbsp;&nbsp;

Forum Discussion

How to copy a file and rename based column contents

Share

Resources