View Single Post
 
Old 01-19-2020, 03:12 PM
OSL OSL is offline Windows 10 Office 2019
Novice
 
Join Date: Jan 2020
Posts: 1
OSL is on a distinguished road
Question Is it possible to compare two PowerPoints with regards to hidden/unhidden text boxes/master slides?

Dear All,

I work in a translation agency where we regularly translate large PowerPoints. It's often the case that, for example, with a German PowerPoint, we hide English text boxes because they are already in English and therefore no longer need to be translated into English. Sometimes the customer himself has hidden additional text boxes because he does not want those to be translated.
After the PowerPoint has been translated, we have to unhide the hidden text boxes again - but only those text boxes that we had hidden ourselves. Those that the client had hidden should remain hidden. In other words, we want to restore the "original state" as it was before the translation.
With PowerPoints that have 100+ slides, this is quite tedious and time-consuming. So my idea was to use VBA to somehow compare the original and translated PowerPoint in terms of what is shown/hidden and then apply the settings from the original to the translation. I saw that in the PPTX-XMLs the strings show="0"/show="1" and hidden="1"/hidden="0" (depending on whether they appear in the slides or master slides) determine whether a text box is hidden or displayed. Would it be possible to change these strings via VBA, e.g changing show="0" to show="1" where this is the case in the original PowerPoint?

I would be grateful for any tips and suggestions!

Many greetings

Oliver
Reply With Quote