Jan 26 2023 08:34 AM
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
Jan 26 2023 11:59 AM
It's possible using the Copy command in a Windows command prompt.
Attached is a workbook with the syntax ready to go.
Jan 27 2023 11:38 AM
Thank you Patrick. I will review and give it a try.
Jan 27 2023 01:25 PM
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\Test
U:\>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.
Jan 27 2023 01:59 PM
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
Jan 30 2023 08:04 AM
@Patrick2788 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.
Jan 30 2023 08:25 AM
Please see attached workbook.
Jan 30 2023 08:46 AM
Still not working. I understand the concept to create a large number of new images by copying an existing image ("No Image.jpg") and renaming it to an actual Item number for a large qty of items (there are about 1,500 we want to assign the No Image.jpg but with the item # as the name) but just does not seem to work. I put quotes around the image being copied with no luck:
U:\>cd C:\Users\pat.myer\OneDrive - A-dec Inc\Desktop\Test
U:\>copy "No Image.jpg" 001.013.01.jpg
The system cannot find the file specified.
Is this Excel to Windows Command process not going to work for my requirements?
Jan 31 2023 05:33 AM