Paste column from Excel to Command Prompt

[dlz217]

I have a spreadsheet that takes a list of file names, modifies new file names, and creates the "ren" command to execute using command prompt. So I may have 50 rows from F2:F51 that look like this:

ren "OLD_NAME.pdf" "NEW_NAME.pdf"

<tbody>
</tbody>

I want to create a macro that pastes this into CMD to run. Normally, you can open CMD and just paste that column manually. Is this possible?

 

[dlz217]

I was able to run CMD and generate the file list using the below. I just need to figure out how to paste the cell value into command.

Dim wsh As Object
Set wsh = VBA.CreateObject("WScript.Shell")
Dim waitOnReturn As Boolean: waitOnReturn = True
Dim windowStyle As Integer: windowStyle = 1


wsh.Run "cmd.exe /S /C cd C:\Users\...\...\... & dir /b > _list.txt", windowStyle, waitOnReturn

 

[Tetra201]

You can rename files using a native VBA Name statement like this:

Name Range("F2") As Range("G2")

where cells F2 and G2 contain the old name and new name, respectively.