top of page

Improving Excel with Python (Day 4 of 5)

My starter scripts in January 2021:

Set the file attributes for multiple Excel files

Setting file attributes for multiple files in one folder can be achieved from the Windows File Explorer window, but doing this across multiple folders can be so time consuming and prone to error that they aren’t updated.

Here’s a snippet that gets the file attributes (the title, description and subject) from a file the user selects, and copies them to all Excel files within a folder.

Tomorrow for the final (and for me the most exciting) part, I’ll explore tracking the changes in an open Excel document to add a live audit feature.

Any thoughts or questions, get in touch


Have a look at the code I used, here:

Recent Posts

See All

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo


Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page