Speed up code to backup file for more than 30 sheets

Hi experts,
I search to improve code speed when create backup from the file .
the file contains about 30 sheets and will increase from time to another.
I suspect slowness code will be from many sheets which contain file .

Please Login or Register  to view this content.

I truly appreciate if anybody improve this code to become more speed.

Yes as obviously the size makes the time necessary so nothing to improve according to speed.
The reason why using Excel like a database software is not such a great idea, could be 100 times slower …

Anyway your code can be revamped as

PHP Code: 

Sub Demo1()
    Application.CopyObjectsWithCells = False
    Sheets.Copy
    ActiveWorkbook.SaveAs "C:\Users\AANI\Desktop\ACCOUNTS\BALANCES MOVEMENT " & Format(Now, "yyyy-mm-dd hhmm "), 51
    ActiveWorkbook.Close
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

A sample file might help

your quick wins are
To have no other workbooks open


to turn off calculation Application.Calculation = xlCalculationManual
turn off screen updating Application.screenupdating=False

no idea if the below is quicker or slower

Please Login or Register  to view this content.

thanks guys , I thought there is better way , but all of your suggestion doesn't make difference , sorry!

As I wrote …

The 'better' way is to not use Excel but a database software.

I do not used to work with database software.
and create codes by database software is really hard for me .
I no know how start to enter guiding database software!

So with Excel just do not complain about / expect speed as it needs more time …

So with Excel just do not complain

I don't complain , just I post to see if it's possible as the rest of members when they ask to make speed their codes.

Try post #2 …

Try post #2 …

I did it, but not really big difference

Am I missing something? Can't you save the workbook under the new name and then delete all shapes, or whatever you want to do, in the new workbook?

delete all shapes takes more time for all of sheets . my goal save the files without any shape and as xlsx to send by email .

Post 2 code takes less than a second with 30 sheets...so what is problem...

what about the original code, how many times takes?

Originally Posted by abdo M

I did it, but not really big difference

You can also try to desactivate the ScreenUpdating during the process.
As there is an unique way to save a new workbook
so asking to « speed up » has no more chance than Poutine to receive the Nobel Peace Prize …

just over a second...

thanks for confirmation .
this means I have to adapt with the original code.