stop opening in protected view microsoft word

Making the folder (where the downloaded file is stored) into a trusted location, but this is not allowed by my user settings. To disable it, uncheck the boxes next to the corresponding items and click OK. Step 4: After the Trust Center dialog opens, select Protected View. Application.AutomationSecurity = msoAutomationSecurityForceDisable Step 3: After the Word Options dialog opens, select Trust Center on the left-side pane, and then click Trust Center Settings button on the right-side pane. Running this line before downloading the file, and also immediately before attempting to turn off Protected View, but still the behaviour is the same. I have tried several methods to fix this:

Run-time error '91': Object variable or With block variable not set The line where I try to assign a value to NameOfNewFile returns an error if I don't use 'Resume Next': If I click Cancel and then F5 (to continue execution) the loop works as it should (protected view is cancelled, the value of TEMP is set to the filename, the loop exits and the macro continues.If I click OK, I keep getting the same messagebox, and the file remains in Protected View.I get a message box saying 'this should not be possible!'.To start Word in safe mode, please press Win+R to open Run in Windows, type WinWord /safe, press Enter to start it. Start Word in safe mode, then open this document to have a try. Click Print Layout view for the opened document. Ttt = MsgBox('this should not be possible!', vbOKCancel) Please go to View tab, in the Views group, check the current view setting.

NameOfNewFile = Left(ActiveWorkbook.Name, 14) My VBA is contained in a separate file 'GetAndAnalyseData.xlsm': NameOfNewFile = 'ooo'Ī 'This never works first time I think it's necessary to disable the protected view so that I can extract data from the file. The file opens in Protected View (yellow banner at top of screen). I need to extract data from a file ('DatabaseExport.xlsx') that has been generated and newly opened from an intranet site.

Stop opening in protected view microsoft word