-->
Applies to: Excel for Mac | PowerPoint for Mac | Word for Mac | Office 2016 for Mac
Use the GrantAccessToMultipleFiles command to request access to multiple files at once in your Office 2016 for Mac solution.
Unlike VBA macros in Office for Mac 2011, VBA macros in Office 2016 for Mac don’t have access to external files by default. Because the Office 2016 for Mac apps are sandboxed, they do not have permission to access external files.
Existing macro file commands prompt the user for permission to access a file if the app doesn’t have access to it. This means that macros that access external files cannot run unattended. The user must approve file access the first time each file is referenced. You can use the GrantAccessToMultipleFiles command to minimize the number of prompts in order to improve the user experience.
Caution: When you create a password for a document, write down the password and keep it in a secure place.If you lose the password, you can't open or gain access to the password-protected document.Passwords in Excel for Mac and Word for Mac have a 15-character limit.
GrantAccessToMultipleFiles command
Use the GrantAccessToMultipleFiles command to input an array of file paths and prompt the user for permission to access them.
| Parameter | Description |
|---|---|
| fileArray | An array of POSIX file paths |
The command returns whether the user granted permission or not.
| Return value | Description |
|---|---|
| True | The user grants permission to the files. |
| False | The user denies permission to the files. |
Note
After the user grants permissions, the permissions are stored with the app. The user doesn’t need to grant permission to the file again.
Example
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
One of the highly used inbuilt applications of Microsoft Windows based systems is Microsoft Office. Microsoft Office is a bundle of programs that includes the text editor, spreadsheet, PowerPoint presentation, and more such. Out of these applications, the text editor of MS Office suite i.e. MS Word is most popular one. Most of the Windows users use this application of Office suite extensively for writing their personal stuff, penning down their official write ups, or doing their school assignments. That means MS Word is used by people of all cadres.
Due to its usability and popularity, we cannot say that MS Word is a robust application instead of many times your MS Word doc too gets corrupt and thus causes data loss stored in them. Generally, a corrupt Word document does not open. Mentioned below are two most common error messages that you may encounter when your MS Word document does not open:
“Word cannot open the document: user does not have access privileges.”
Or
“Word cannot open the document.”
However, this behaviour can also be exhibited by MS Word when you are trying to open it in an older version. If this is not the case, then before troubleshooting, it is suggested to understand the exact factors that are causing such unexpected behaviour. Therefore, first of all, you should check your document in question for this behaviour through the below-mentioned steps:
- Check out whether the similar resolution as mentioned above seen in other Word documents. If the problem within this document only, then:
- Take this document to another computer and try to open this file there. If your Word file is duplicating the behaviour there as well, then your doc file is corrupt.
Microsoft Access Software For Mac
Follow the below steps to rectify your problem and repair your Word file in such case:
Microsoft Access Mac Free Download
- Open your Word document in Draft mode: At times, opening the damaged Word document in the proposed mode without updating the links can open it.
- Open a new Word document and try to insert the damaged document as a file in it: Open a new Word document and try to insert your damaged document as a file in this new doc. This, many times, solves your problem.
- Force MS Word to recover your corrupt file: In most of MS Word corruption errors, you will be able to open your corrupt Word file by following the above two methods, but even after that, you may find some ambiguities in it. Ambiguities like unreadable texts on your Word doc or other such behaviours are seen. In such situations, you can try ‘Open and Repair’ utility of your MS Word to force it to repair the corruption in the selected Word file and then open it.
- Try Stellar Repair for Word software: However, if none of those mentioned above resolutions works to rectify your issue, then use of Stellar Repair for Word software to fix the MS Word document issue. It repairs corrupted .docx and .doc files created in MS Word 2013 to 2000 and supports Windows 10, 8, 7, Vista, 2003, XP, 2000, & NT.
With the help of the above-mentioned resolution steps, you for sure will rectify Word document corruption and get back your precious data stored in them.