I have a current macro that works...opens files, updates, saves, then close. See below.
We are having issues with the Protected view prompt, enable editing. This stops our macros, and we run through about 25 files with this current macro. How do I add the VB "Unprotect" statement that will turn this off on every file when it is opened, before the update begins?Sub TestUpdate() Workbooks.Open Filename: = V:\user folder\filename.xls, updatelink:=3 ActiveWorkbook.Save ActiveWindow.Close End Sub
Thank you for your help !!