Excel 4.0 Macros over the network doesn't work

%3CLINGO-SUB%20id%3D%22lingo-sub-1717204%22%20slang%3D%22en-US%22%3EExcel%204.0%20Macros%20over%20the%20network%20doesn't%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1717204%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20open%20Excel%204.0%20Macro%20using%20%22Workbooks.open%20()%20runautomacros%22%20over%20the%20network%2C%20the%20file%20gets%20corrupted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EWorkbooks.Open(Filename%3A%3D%20_%0A%22%5C%5CFileServer%5CShareFolder%5CSubFolder%5CWithExcel4.0MacroSheet.xls%22).RunAutoMacros%20_%0AWhich%3A%3DxlAutoOpen%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20worked%20fine%20a%20few%20months%20ago%2C%20but%20I've%20been%20having%20this%20problem%20ever%20since.%3C%2FP%3E%3CP%3EI%20referred%20to%20the%20internet%20information%20and%20tried%20the%20following%2C%20but%20it%20doesn't%20improve.%3CBR%20%2F%3E-%20Add%20a%20folder%20on%20the%20network%20to%20Excel%20Option%26gt%3B%20Trusted%20Locations%3CBR%20%2F%3E-%20Latest%20version%20of%20Microsoft%20365%20%5Bversion%202008%20(build%2013127.20508)%5D%3CBR%20%2F%3E-%20Revert%20Microsoft%20365%20to%20the%20previous%20version%20%5Bversion%202002%20(build%2012527.20278)%5D%3CBR%20%2F%3E-%20Stop%20virus%20software%3C%2FP%3E%3CP%3E(My%20PC%3A%20Windows10%20Pro%20%5Bversion%202004%20(build%2019041.508)%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20guessing%20that%20Microsoft's%20update%20has%20added%20security%20restrictions%2C%20but%20I%20don't%20know%20the%20solution.%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20any%20suggestions%20or%20assistance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1717204%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

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!

0 Replies