Forum Discussion
How to copy a file and rename based column contents
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...
Please see attached workbook.
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?
- You could try using the local path on C to the files instead of the OneDrive path. Presumably, the files are on your desktop in the example you posted which synchronizes to OneDrive. There's also a local path:
cd C:\Users\pat.myer\Desktop\Test