You can post urls but I cannot!
You are not allowed to post any kinds of links, images or videos until you post a few times
Thanks for those url’s – I have seen them and have been in dialogue with Nigel at Warwick.
no clue what you're saying
I’ll give more details.
I have previously published addin code to do conversions involving British map references, to manipulate gpx files,
plot on Google Earth and get postcode coordinates.
Following an approach from a MAC user we’ve been trying to port it to MAC and the modified code has been tried on
three different MAC systems. So far about 100 iterations of the code! Encouragingly, the custom ribbon menus,
cartographic conversions, iterative routines, recursion, dictionaries, XML parsing and cell handling all worked fine.
It was when we got to file handling that it all fell apart due to sandbox restrictions.
Under Windows you’d get the name of a file to write to with:
With MAC unfortunately that is unstable – it locks Excel up requiring the MAC equivalent of ctrl/alt/del and
killing the excel process.
Instead, you have to delve into Applescript to choose the file. This works and is very stable:
Now the file holding that applescript has to be in a particular named folder:
.
This requirement is part of the sandbox restrictions placed on Office.
Under MAC Excel 2016 and Excel2019 that folder is created (I presume) as part of the Office install process. On the Office 365 system the folder was missing so was created manually.
The Applescipt above fails with 365 and that manually created folder – it ‘spins’ until MAC OS times it out.
I am left with the question ‘what is the difference between a manually created folder and an office installation created one?’
Hence the reference to attributes/properties.
Phil
Bookmarks