To make sure that each change was not effected by the debugger. Screen Updating will always show True in the debug window.I turned off the debugger and tried the same code and it flickers between the books. But that shouldn't alter the way it works when a routine / function is run.Display Alerts = False Fname = "C:\Users\Downloads3.zip" If Fname = False Then 'Do nothing Else 'Destination folder Def Path = "C:\Users\documents\adsl" If Right(Def Path, 1) "\" Then Def Path = Def Path & "\" End If File Name Folder = Def Path 'Extract the files into the Destination folder Set o App = Create Object("Shell. Please add at the top On Error Goto err Trap and at the bottom add this to the end sub Exit Sub err Trap: Msgbox " the error reported is " & err.number & " " & err.Description End Sub ' don't repeat the end sub, this is just for your reference.To evaluate this better, can you post a sample file which replicates the scenarios you explained above?I already tried using Workbooks versus Windows and there was no difference, however the instance idea is interesting.
Windows 8 ignores the screenupdating = false when it goes between instances.also, please comment out your On Error Resume Next Run this again and see if there are no errors thanks RX- I did not even see the on error resume next I give your code3 a go to see what I get.I have VBA code that works under windows 7 and excel 2013.The save time for this large file as a normal XL2000 file is 10 seconds. If you are saving as Microsoft Excel 97-2000 & 5.0/95 Workbook *you will see the following Microsoft Excel 5.0/7.0 saving on your status bar where you normally see Ready toward the end of the save then you are saving in multiple formats.If the file is accessed only in one version, you don’t want to use this feature.