Please help me to see how read-only way to open the protection of the excel file. Again use Au3 can read excel to get the data. If you are using excel to manually open this file, you can click excel above the protected view - edit anyway to lift the protection (only need to set once, office will remember that this file is trusted). Go to the Protected View tab in the trust center and then uncheck the bottom box titled Enable Protected View for Outlook attachments. Read More: Cannot Edit Excel File in Protected View (3 Reasons with Solutions) 2. Now see, the Protected View mode is removed. From the options, menu select Trust Center > Trust Center Settings. Click the Enable Editing Button under the ribbon bar that you will get after opening a downloaded or collected Excel file. The above code has been tested if the open excel file is protected, such as the file is downloaded from the network, or U disk, or above the office version of Office opened 97 office xls file, excel default security options will prompt the excel file Is protected, and can not be modified by default (unless all protection is turned off in the office's options - trust settings). To disable it, open Microsoft Word, Excel, or Powerpoint, etcand then click File » Options. transpose ( $EmpList ) _ArrayDisplay($EmpList). xls ) If Then MsgBox ( 16, 1, "Error" ) With $lastSummaryXls. $lastSummaryXls = ObjGet (
0 Comments
Leave a Reply. |