Saving Spreadsheet

[Jahay]

I keep financial records on a disk. I would like to have a backup disk, but
it will not allow me to save it as I have to take out the disk. When I
remove the current disk I loose the file. Can I copy and paste? If I can
do I have to formatt all these new disks before I put them in? I never had
to formatt disks with my old computer. Thanks, Jahay

 

[Carey Frisch [MVP]]

What type of disc...floppy, CD, DVD,?

--
Carey Frisch
Microsoft MVP
Windows Shell/User

---------------------------------------------------------------

I keep financial records on a disk. I would like to have a backup disk, but
it will not allow me to save it as I have to take out the disk. When I
remove the current disk I loose the file. Can I copy and paste? If I can
do I have to formatt all these new disks before I put them in? I never had
to formatt disks with my old computer. Thanks, Jahay

 

[Bob]

Yes you can copy and paste.

Another option is to write a simple batch file like this:

xcopy /y [path]\[filename] [drive letter:\folder name]

I use a similar batch file to copy important spreadsheets to 4 locations
with one mouse click.

I don't understand what you mean when you say "it will not allow me to save
it as I have to take out the disk. When I
remove the current disk I loose the file."

BTW It's "lose" not "loose"

 

[Jahay]

It is a CD.

 

[Jahay]

Thanks for your response. When I take out the CD the file leaves the screen.
It tried saving by taking out the disk and putting the other one in, but it
did not stay on the screen. I thought I could possible drag it to another
CD, but would have to save to hard drive. Yes, I am a very poor speller!

Yes you can copy and paste.

Another option is to write a simple batch file like this:

xcopy /y [path]\[filename] [drive letter:\folder name]

I use a similar batch file to copy important spreadsheets to 4 locations
with one mouse click.

I don't understand what you mean when you say "it will not allow me to save
it as I have to take out the disk. When I
remove the current disk I loose the file."

BTW It's "lose" not "loose"

I keep financial records on a disk. I would like to have a backup disk,
but
it will not allow me to save it as I have to take out the disk. When I
remove the current disk I loose the file. Can I copy and paste? If I
can
do I have to formatt all these new disks before I put them in? I never
had
to formatt disks with my old computer. Thanks, Jahay

 

[Carey Frisch [MVP]]

You have to record (burn) the file to a CD, not save it to a CD.

Burn a CD or DVD:
http://windowshelp.microsoft.com/Windows/en-US/help/b47eb51a-ea6d-4d97-97b0-2d07a59316981033.mspx

 

[Bob]

I find that I can save a file directly to a CD if I first create a new
folder and save the document to that folder.

 

[Jahay]

Thanks you both helped!!!! Actually I finally did burn it to the CD. New
computer after leaving a Windows 98. A bit of a learning curve. Jahay