Very many thanks for both the code and detailed explanation.
I will look for your 'rant in Meditations' in the hope that it will help me to understand more about controlling Excel with Perl.