{"id":13248,"date":"2016-01-10T13:01:44","date_gmt":"2016-01-10T18:01:44","guid":{"rendered":"http:\/\/mjtsai.com\/blog\/?p=13248"},"modified":"2016-01-10T13:01:44","modified_gmt":"2016-01-10T18:01:44","slug":"office-2016-sandboxing-and-vba-code","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2016\/01\/10\/office-2016-sandboxing-and-vba-code\/","title":{"rendered":"Office 2016, Sandboxing, and VBA Code"},"content":{"rendered":"<p><a href=\"http:\/\/www.rondebruin.nl\/mac\/mac034.htm\">Ron de Bruin<\/a>:<\/p>\n<blockquote cite=\"http:\/\/www.rondebruin.nl\/mac\/mac034.htm\">\n<p>In Windows Excel 97-2016 and in Mac Excel 2011 you can open files or save files where you want in almost every folder on your system without warnings or requests for permission. But in Mac Office 2016 Microsoft have to deal with Apple&rsquo;s sandbox requirements. When you use VBA in Mac Excel 2016 that Save or Open files you will notice that it is possible that it will ask you permission to access the file or folder (Grant File Access Prompt), this is because of Apple&rsquo;s sandbox requirements. This means that when you want to save\/open files or check if it exists with VBA code the first time you will be prompted to allow access on the first attempt to access such a folder or file.<\/p>\n<\/blockquote>\n<p>He recommends putting your documents in the Library folder:<\/p>\n<blockquote cite=\"http:\/\/www.rondebruin.nl\/mac\/mac034.htm\"><p>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. 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.<\/p><\/blockquote>","protected":false},"excerpt":{"rendered":"<p>Ron de Bruin: In Windows Excel 97-2016 and in Mac Excel 2011 you can open files or save files where you want in almost every folder on your system without warnings or requests for permission. But in Mac Office 2016 Microsoft have to deal with Apple&rsquo;s sandbox requirements. When you use VBA in Mac Excel [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"apple_news_api_created_at":"","apple_news_api_id":"","apple_news_api_modified_at":"","apple_news_api_revision":"","apple_news_api_share_url":"","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_is_hidden":false,"apple_news_is_paid":false,"apple_news_is_preview":false,"apple_news_is_sponsored":false,"apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":"\"\"","apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"footnotes":""},"categories":[2],"tags":[30,1199,609,577,71,53,1329],"class_list":["post-13248","post","type-post","status-publish","format-standard","hentry","category-technology","tag-mac","tag-mac-os-x-10-11","tag-microsoft-excel","tag-microsoft-office","tag-programming","tag-sandboxing","tag-visual-basic-for-applications-vba"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/13248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/comments?post=13248"}],"version-history":[{"count":1,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/13248\/revisions"}],"predecessor-version":[{"id":13249,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/13248\/revisions\/13249"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=13248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=13248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=13248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}