Sep 27 2020 01:02 AM - edited Sep 27 2020 01:14 AM
When I open Excel 4.0 Macro using "Workbooks.open () RunAutoMacros" over the network, the file gets corrupted.
Workbooks.Open(Filename:= _
'\\FileServer\ShareFolder\SubFolder\WithExcel4.0MacroSheet.xls').RunAutoMacros _
Which:=xlAutoOpen
It worked fine a few months ago, but I've been having this problem ever since.
- I referred to the internet information and tried the following, but it doesn't improve.
- Add a folder on the network to Excel Option> Trusted Locations
- Latest version of Microsoft 365 [version 2008 (build 13127.20508)]
- Revert Microsoft 365 to the previous version [version 2002 (build 12527.20278)]
- Stop virus software
* My PC: Windows10 Pro version 2004 (build 19041.508)
I'm guessing that Microsoft's update has added security restrictions, but I don't know the solution.
Thank you in advance for any suggestions or assistance!