Yeah, good idea, thanks Dave........I never messed with the .xlb file
before........thanks for the suggestion.
I also keep all the old versions as I progress along with a programs design.
I use dates, andRev numbers and letters, anything to make it different and
consecutive. I even save when someone comes up and interrupts me. I've had
several occasions where some change the Client had me make caused some
feature to take a dump, and I just go back to where I have two consecutive
saves, one in which the feature worked and the next in which it don't and
then I can usually find out by looking at them what I did
wrong.........saved my bacon a number of times.........
Vaya con Dios,
Chuck CABGx3
"Dave Peterson" wrote in message
...
You may want to include a copy of your xlb file, too.
I actually kept my development names as:
nameofworkbook_yyyy_mm_dd.xls
But I'd rename the general copy when I put it in that location.
(I actually kept a giant .zip file of almost all the versions for
historical
purposes. You never know when you're gonna have to prove to someone that
it
wasn't a program error <vbg.)
CLR wrote:
LOLOL...........I hear ya Dave. I would never deny the importance of
backups. The way I use my JumpDrive is to change the name/rev of the
file
every time I work on it, so I constantly have current "backups". Then
when
I'm done and the program works, I remove the old versions. This
technique
has saved my bacon on numerous occasions when "things went
wrong".......I
could go back in versions until I found one where that feature still
worked
and then compare it to the next version to find the trouble. I learned
this
the hard way from working on a sleazy network that failed several times
a
day. As for "pushed to the limit", I usually keep about 25% of my jump
drives with a directory of music, so I can drown out the local
chatter/noise
wherever I'm working.........when I get close to the limit on that
drive, I
just dump the music directory and that gives me plenty of space
left.......then when I have time I can archive and clean up the drive.
I
agree, with smaller drives it takes a bit of "management", to keep from
maxing them out considering the way Excel saves files, but JumpDrives
sure
are convienient for personal security, and for transferring files from
one
computer to another. I also keep my personal.xls there as well as
various
Add-ins, and even an Image-editing program that I might need when I go
from
location to location.......I really wish I could set up the entire
Office
Suite on a JumpDrive, but haven't been able to figure out a way to do
that
yet.
Vaya con Dios,
Chuck, CABGx3
"Dave Peterson" wrote in message
...
I agree with almost everything you wrote.
Except for the pushed to the limit portion.
If have a drive with 5 meg available and open a 4 meg file, I may
assume
that
when I save it (with no changes even), it'll fit. But that's not the
way
excel
works. This can cause more heartache than it's worth.
I know the most important file I had at work was saved to my home
drive on
a
network share, copied to a common network share (twice--once for use
and
once
for common backup).
I'd save a copy on my harddrive and put a copy on two thumb drives (so
I
could
create a copy on my harddrive at home, too).
I'm not sure I'd want to keep one copy of anything
important--including on
a
jump drive.
It was a pain making backups and I don't recall any failure of any
type,
but I
slept better!
ps. lots of people only had trouble once when they save to floppies,
too.
But
once is more than enough.
Dave "belt and suspenders" Peterson
CLR wrote:
Uh-huh, uh-huh, and if a hard drive runs out of space, even more
"bader"
things will happen, and that's a "for-sure".........but as with
anything
else, the JumpDrive must be used within the parameters that exist
for
it.
NO memory device operates reliably when pushed past it's limit, Hard
Drives
included. The JumpDrive is a very effective way of moving files
around
from
office to office, especially when the offices are not even with the
same
company and are not hooked together with a network.......or the
network
has
so many "MIS monitoring features" on it the computers will hardly
run
anyway. Like I said, I have been doing it with 4 different
JumpDrives
for
a couple of years and no problems........that's not personal
opinion,
that's
actual FACT.....and the best part is, NOone has access to those
files
but
ME. As for losing a JumpDrive, or the keys to your car,
........well,
thats
not really a legitimate reason for not using JumpDrives or cars
either
one.
The OP wanted to know about moving files from computer to computer
with
a
physical device that he could take with him. I've told him of my
actual
experience in doing so, and what I think is the best way to do that.
Vaya con Dios,
Chuck, CABGx3
"Dave Peterson" wrote in message
...
When excel saves a file, it saves it as a new name first. If that
works
ok, it
either deletes the original or
renames it to something like "backup of book1.xlk".
And then renames that temporary file to the original file name.
If you run out of space on that thumb drive, then bad things can
happen.
Dave Peterson wrote:
It's very difficult to remove your harddrive while you're
editing
the
file.
And as large as those jump drives are, there is usually lots
more
real
estate
available on a harddrive.
When excel saves a file, it renames the original file, creates a
new
file. If
that works ok, it either deletes the original or renames it to
something
like
"backup of book1.xlk". If you run out of space on that thumb
drive,
then bad
things can happen.
And a side benefit of saving to a harddrive and copying to the
thumb
drive is
that you have a backup.
(I bet more thumb drives are just plain lost than desktops or
even
laptops.)
CLR wrote:
Pray tell "Why"?................I have personally been working
off
of
various types of Jump Drives for a couple of years with nary a
problem............I can understand it with Floppies, and I
suppose
anything
is possible, but I cannot even begin to concieve how working
off a
mechanical Hard Drive would be considered more reliable than a
solid
state
Jump Drive.
A complex technical explanation will suffice.........
Vaya con Dios,
Chuck, CABGx3
"JoAnn Paules [MSFT MVP]" wrote in
message
...
Even then, the file should be saved to the hard disk before
changing
it.
--
JoAnn Paules
MVP Microsoft [Publisher]
"CLR" wrote in message
...
Technically, what you are wanting to do is
possible.........however,
Floppy
Disk Drives are mechanical devices and therefore
inherently
subject to
failure which could result in data loss. You would be
much
better
off
using
one of the new pocket "jump" drives, they hold a LOT more
data
than a
floppy
disk and are considerably more reliable.
Vaya con Dios,
Chuck, CABGx3
"Martie1949" wrote in message
lkaboutsoftware.com...
I have a monthly expense I set up in excel. I have to go
from
office to
office to different computers so if I add in an expense
can
or
will the
update be saved in the floppy or how can I save the
changes?
--
Dave Peterson
--
Dave Peterson
--
Dave Peterson
--
Dave Peterson
|