Doing the save twice - to the same file name - will not improve your
chances. The two saves would need to be to different file names, using
Save As.
I am in the habit of always using Save As during development of a
workbook. I simply append a new version number to the file name each
time. E.g. while developing Fred.xls, I would save
Fred x1
Fred x2
etc
The "x" is a reminder to myself that these are development versions.
Once a workbook has finished development, I save it again, without the
version number and zip up the development versions for short-term
archiving.
When a workbook is "in production", I simply rely on an automated backup
procedure to make sure that I always have several previous edits of the
workbook if I need to regress.
Regards, Dave S
________________________________
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of Adrian Mollenhorst
Sent: Monday, 20 February 2012 19:26
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] 2010 Crash
Thanks Paul,
Interesting that you suggest it might be a corrupt save. Perhaps I
should
save twice when I save, so reduce the chances of this happening on both
saves.
Adrian
On Sun, Feb 19, 2012 at 8:21 PM, Paul Vermeulen <
paul.vermeulen@vulcantech.com.au
<mailto:paul.vermeulen%40vulcantech.com.au> > wrote:
> **
>
>
> Hi Adrian
>
> I use the 32 bit version of Office 2010. Have had no issues with it. I
> ALSO use Excel 2003, and I find the 2010 Excel more stable when I push
> the limits of the application's code execution. Has to do with larger
> limits for workbook sizes, memory usage, etc.
>
> Glad you recovered your workbook. Sounds like a corrupt save, by the
> way.
>
> Regards
>
> Paul
>
> From: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
[mailto:ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> ]
On
> Behalf Of Adrian Mollenhorst
> Sent: Sunday, 19 February 2012 9:58 PM
> To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
> Subject: [ExcelVBA] 2010 Crash
>
>
> Hi All,
>
> I have recently begun using VBA code quite a bit with my 64bit Office
> 2010.
> Today I tried to open my spreadsheet only to find Excel crashed every
> time
> I tried to open the workbook. I have managed to go back to a previous
> version of the workbook, and lost only a few hours of work, but in my
> attempt to recover, I found quite a bit of info on the web about the
> dubious reliability of Excel 2010. I'm not sure if this is indeed
true,
> and
> wanted to get the experts (you guys) opinion, and if it is true, whats
> the
> best way to safeguard my work moving forward?
>
> I really love excel 2010, so I don't want to downgrade if I don't have
> to,
> and don't want to speak ill if of a great product if indeed this is
just
> a
> once off issue.
>
> Cheers!
>
> Adrian
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
----------
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar