We use a simple PowerShell script to run the check (you can interact with any office doc as a ComApplication object) and it took only a few hours of digging through the properties / MS docs to get what we needed.
We use a simple PowerShell script to run the check (you can interact with any office doc as a ComApplication object) and it took only a few hours of digging through the properties / MS docs to get what we needed.
I miss those days, simpler, more fun times. I was given a problem and asked to solve it. No pressure on hours or anything else. (I did get it done relatively fast...a couple weeks I think). We didn't have SCRUM or sprints or anything, and we only had to give rough estimates for deliverables.
The problems were interesting, and there was always a challenge.
My how times have changed.
$excel = New-Object -ComObject excel.application
From there you have full access to all parts of the document as properties & can call whatever methods are available to edit the document.As for how we enforce style guide on a presentation, each slide runs through a workflow checking the various style-guide rules that we have / corporate has
- Ensure correct template is used
- Set and enforce correct font
- Check text boxes for font size to check verbosity / readability
- Flag / remove animations (not accessible)
- Flag images without alt-text
and so on
for a 300 slide new release presentation, it takes about 45 seconds for the script to process and auto-fixes what makes sense to auto-fix (e.g., wrong fonts) and adds comments / generates report on what needs to be reviewed and adjusted