Tks Dave for your answer and suggestion.
ref # 1. I had 3 corrupted files. Tku !!!
Os
--------------------------------------------------
On Feb 17, 10:03 am, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> #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.
>
>
>
> Os wrote:
>
> > 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.
>
> --
>
> Dave Peterson
