Hi Paul,
I found this page when looking into the different file paths in macs.
http://www.rondebruin.nl/mac.htm

I'm wondering if the answer is in the section called "Get Path of Special Folders". It gives some code there, but I'm not sure where to insert it. (It looks like VBA, but it calls it 'mac script' and 'apple script' which is very different.)