OfficeFolder = MacScript("return POSIX path of (path to desktop folder) as string") 'Function to create folder if it not exists in the Microsoft Office Folder 'Create folder if it not exists in the Microsoft Office FolderĬall CreateFolderinMacOffice(NameFolder:="MyProject")įunction CreateFolderinMacOffice(NameFolder As String) As String To get this Excel path you can also use Environ("HOME") or Environ("CFFIXED_USER_HOME") If you want to have a location only for Excel for example use this path : /Users/rondebruin/Library/Containers//Data I not use this location on this example page to be sure that every Office program can access my files if this is needed. The folder above you can use to share data between Office programs or with a third party application, so this location will always work if you want to have read and write access. Note: rondebruin is the user name in this path and I agree that the naming of the folder for Office( UBF8T346G9.Office) is not so nice, but Microsoft do not have control of this name. Users/rondebruin/Library/Group Containers/UBF8T346G9.Office This is the Root folder on my machine that we use in the examples on this page: But these folders are not in a place that a user can easily find so below are some steps that I hope to make it easier for you to access the folder manual if you want. There are a few places on your Mac that you can use to avoid the prompts and let your code do what it needs to do without user interaction.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |