How can I save a file to a floppy disc?

[Guest]

I am trying to save a file to a floppy disc. Can't find a way. Help!!

 

[Gord Dibben]

You can through VBA save directly to a floppy but...................

You should not save directly to a floppy.

You will eventually wind up with a corrupted file.

Save to Hard Drive first then copy to the floppy.

Same goes for opening files from any removable media.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Saving files directly to removable media can cause trouble.

You'd be better served to save to your harddrive/lan drive and then use windows
explorer to copy to that floppy.

 

[Bernard Liengme]

Does this advice apply to a 'thumb drive' when one observes the protocol of
using the Safely Remove Hardware tool each time? So far the gods have been
good to me on that score!
Happy New Year

 

[Gord Dibben]

Bernard

I think if the drive is large enough to hold all the extra tmps that Excel
builds you probably won't run into any problems.

With the USB thumb sizes they have now the "never do it" advice may be overkill.


Gord

 

[Dave Peterson]

Even with lots of space on my thumbdrives, I try not to work on files that are
stored on them. It may be overkill, but by working on copies on the harddrive
and copying to (and from) the thumbdrive, I have a backup built into my
procedure.

And even if I use the "safely remove hardware" tool each time, I could eject
that drive while the file was still being edited.

There have been a few discussions about this in these here newsgroups. Some
people have stated that they work off them all the time and have never had a
problem.

I keep thinking "yet"!

=====
And I have a USB 160GB harddrive that I treat the same way--so it's probably a
preference more than a rule--but it can't hurt <vbg>.

 

[Gord Dibben]

My sentiments also, just stated more articulately.

Happy New Year Dave

 

[Dave Peterson]

Happy New Year to you, too, Gord.

My sentiments also, just stated more articulately.

Happy New Year Dave