excel - How to get a shell scripted change to be recognised by an open application -
excel - How to get a shell scripted change to be recognised by an open application -
i have particular problem because of bug affecting date formatting in vba/excel 2011
mac osx 10.10
.
i have found can work around bug changing part setting - in systempreferences / language & region
- non-gmt locale. instance, if alter part united kingdom
italy
, bug doesn't occur.
i've been developing macro runs applescript
, in turn runs shell script, alter setting using defaults utility. shell script i'm using this:
defaults write nsglobaldomain applelocale en_gb
the intention beingness on opening excel, the value of applelocale
changed, bug gone , then, on closing, value of applelocale
reverted previously.
changing setting of applelocale
programmatically on opening excel works fine. excel picks alter if restart application. however, if create alter part setting using scheme preferences gui, don't need restart excel recognise change.
i want avoid gui scripting, i'm wondering if clever bod out there might know why scripted alter isn't recognised. can else forcefulness excel recognise scheme change?
excel osx shell excel-vba-mac applescript-excel
Comments
Post a Comment