How can I create this file from scratch with no inline rename option: "parent folder name - test.xlsx"
In other words, the excel file should have the parent folder name in it followed by a fixed string (e.g. "- test")?
For a folder called "John Doe" the created file should be "John Doe - test.xlsx".
One more thing: How can I copy a template file from a fixed location
"D:\Clients---CC Dampness Report.docx"
and rename it to "Dampness Report {parent} to include the directory name in it?
For John Doe directory the template file would be copied over to (here) and renamed to "Dampness Report John Doe".
Thank you again.