If I could rename the whole thing I would be done. This is a tool that will do that for you automatically. In addition, it can automatically locate existing files (by name) which match a range of filenames, and rename, update, etc. the files that were located by name. It also has a feature called, PDF renaming. The New-Item cadet in PowerShell The new-item cadet is a powerful comb method (crib is French for a combination of combination, method, command…). It is not only powerful; it is also easy to use. It works by piping the target of an item. Therefore, if you call New-Item (My Documents folder) it will generate a report on the contents of the Documents directory in that folder and all subdirectories. This tool works for files and folders as well for files in the current directory. Sep 20, 2024 — I've been working on a simple script that creates a list of all .xlsx worksheets with all properties (add/remove/get) in a specific folder. I'm now wondering if I can create a script that creates a new worksheet, renames it to “test sheet 1” and deletes the original worksheet 1 and adds a row with “test row 1”, adds the row, inserts “Row A” and removes the original “row 1” Sep 20, 2024 — PowerShell's Add-Item cadet allows you to list all the properties of a file, but I'm having a lot of trouble separating each value. How do I determine which property is set or not? Is there a command that can do this more efficiently? Can I create a simple script that generates the value of the property of any file, then I get that object (which would have the same structure?) in an if statement.