![]() ![]() Take care! The Protected View security feature is considered important, as the code used to open and save older file formats may have vulnerabilities that hackers can exploit. This article describes how to change Excel File Block settings to ensure that selected old file types are opened as normal by Excel. Or, if your File Block settings are set to Do not open selected file types, the file won't even open in Protected View, and instead an error message appears. Instead, it either causes the file to open in Protected View, and disables the Save and Open features. When you try to open file types created in previous versions of Office (like an Excel 95 spreadsheet for example), the file will open in Protected View by default, and the editing functions will be disabled.įile Block prevents outdated file types from opening as normal. Please help me to see how read-only way to open the protection of the excel file.Changing File Block settings to enable old Excel file types to be opened as normal 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). 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). transpose ( $EmpList ) _ArrayDisplay($EmpList). xls ) If Then MsgBox ( 16, 1, "Error" ) With $lastSummaryXls. $lastSummaryXls = ObjGet ( & "\" & 07Summary. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |