Save

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig Coope - 19 Apr 2007 20:08 GMT

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...

--
The Zero ST

Reply to this Message

Gord Dibben - 19 Apr 2007 21:10 GMT

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

>I have a activeworkbook.save command as stated in a previous post but
>I'm not quite happy with it...
[quoted text clipped - 11 lines]
>
>Thanks...

Reply to this Message

Craig Coope - 19 Apr 2007 21:24 GMT

> Craig
>
[quoted text clipped - 6 lines]
> 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.

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....

Reply to this Message