Ms access screenupdating

Example using XL2000, my 2.16MB file was saved as a 3.85MB file and took 45 seconds to save first time with Save As, and over one minute with subsequent Save.

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.

ms access screenupdating-47ms access screenupdating-84ms access screenupdating-70

Situation 2: When you are saving a file with already existing file name, Excel popup a warning message.

Please also include your version of Excel and Operating system if you did not originally provide that information.

Wastes space (takes twice as much space, 75-100% more) and takes much longer to process a save.

Value = " VBA Tutorials" 'Make sure that you are enabling the events once you are done with your task Application.

Status Bar = "" End Sub You can suppress the Waning alerts by disabling the display alerts.