I'm currently using Robocopy to move specific files to a destination folder, and since the source file names and destinations change often, I've been using Excel to modify the command easily. I copy the commands from different cells over to either Command Prompt or PowerShell. This worked perfectly on Windows 10, but now that we've upgraded to Windows 11, I keep encountering a problem where a prefix like './.cisco(ps)' or '.cisco(cmd)' is automatically added every time I paste a command. Does anyone have suggestions on how to disable this auto-prefix? I'm also exploring using Excel VBA to create a button or macro that can execute commands from the cells, but I'd like to resolve the pasting issue first.
2 Answers
You might need to share some screenshots, as there could be multiple factors at play, including Windows, Excel's behavior, or how the terminal handles the clipboard.
Man, using Excel as your IDE for this is quite unusual. But hey, whatever works, I guess! Just make sure your setup is clean, since running complex commands through Excel can only complicate matters further.
Right? Sometimes it's better to keep things simple. I went through a long process just to clean up a similar mess with scripts; let's just say it wasn't pretty!
I feel you! I've seen some wild setups too. I had a coworker who insisted on using Excel for everything, even though it added so many unnecessary steps. At some point, it just becomes a hassle.