Save

C

Craig Coope

I have a activeworkbook.save command as stated in a previous post but
I'm not quite happy with it...

Basically it takes too long to save. I'm usuing an old PC and it takes
about 3 seconds to save. However if I only have the speadsheet open
(and not my forms) it saves really quick.

I'm assuming the activeworkbook.save is saving everything (all sheets
and probably all the code in my forms) but I only need it to save the
data in sheet1.

I have searched for another save but can't seem to find. Is there a
sheet1.save option?

Thanks...
 
G

Gord Dibben

Craig

Excel's File>Save saves the entire workbook.

As does Activeworkbook.save

You cannot save just parts of a workbook selectively.

I personally do not consider 3 seconds to be too long, but I am a retired person
and a few seconds is no longer of any import.


Gord Dibben MS Excel MVP
 
C

Craig Coope

Gord Dibben said:
Craig

Excel's File>Save saves the entire workbook.

As does Activeworkbook.save

You cannot save just parts of a workbook selectively.

I personally do not consider 3 seconds to be too long, but I am a retired person
and a few seconds is no longer of any import.
Click to expand...

I do not consider it too long generally but I am using the forms I have
written at my work and making the system as quick as possible will keep them
happy and not complaining about any queuing times.

Hmmm...I'm curious about the difference in save times then. I'm actually
using the disk icon at the top but that should just be a shortcut to
file>save. I wonder why it is a lot faster than the activeworkbook.save
code...

Thanks Anyway....
 
Top