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
>I am trying to save a file to a floppy disc. Can't find a way. Help!!
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

Signature
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
> You can through VBA save directly to a floppy but...................
>
[quoted text clipped - 9 lines]
>
>>I am trying to save a file to a floppy disc. Can't find a way. Help!!
Gord Dibben - 31 Dec 2006 23:29 GMT
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
>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
Dave Peterson - 01 Jan 2007 00:41 GMT
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>.
> 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
[quoted text clipped - 18 lines]
> >
> >>I am trying to save a file to a floppy disc. Can't find a way. Help!!

Signature
Dave Peterson
Gord Dibben - 01 Jan 2007 01:20 GMT
My sentiments also, just stated more articulately.
Happy New Year Dave
>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
[quoted text clipped - 36 lines]
>> >
>> >>I am trying to save a file to a floppy disc. Can't find a way. Help!!
Dave Peterson - 01 Jan 2007 02:06 GMT
Happy New Year to you, too, Gord.
> My sentiments also, just stated more articulately.
>
[quoted text clipped - 40 lines]
> >> >
> >> >>I am trying to save a file to a floppy disc. Can't find a way. Help!!

Signature
Dave Peterson