I am not able to do this...

O

Os

I apologise cause of my lack of knowledge to do this.

I have 2 questions

1) I need to copy all my excel files to a pen drive or CD. so, i
searched them by using
XP search function. I selected all, copied and pasted to pen drive
but a prompt was immediately received "cannot read from source file
or disk "

2) When a Excel file is generated and saved, can it be automatically
saved in a different file
in order to have all xls files duplicated in one XLS Folder ?

Can I received some help to solve this matter ? I will be very
appreciative
of it.

Os.
 
D

Dave Peterson

#2. You could have a macro that does this sort of thing. But I think it would
be complicating things too much--and lots of things could go wrong. If you
chose to have the file saved directly on the USB drive, and that USB drive isn't
inserted (or out of space), then things would go wrong.

You'd have to build that kind of check into your routine.

I'd do exactly what you're doing. Save the files to the local harddrive and
then use windows explorer (or windows|Search) to copy from the harddrive to the
other media.

#1. Do any of the files get copied successfully?
Can you open that troublesome file in excel?

I think I'd try to find out what's going on here. If it's just a single file
that's corrupted badly enough so that windows can't even read it (either to copy
it or to open it in Excel), then it sounds bad. Maybe running windows chkdsk
from a command window would help.
 
Top