Recovery

C

Clayton

I have recovered over 1000 excel and word files from a disk I formatted by
mistake, now I have to go through each one to see if I want to keep it or
delete it and to rename each file, is there a way I can view each file by
the press of a button instead of opening them one by one?

Thanks
 
N

Nick Hodge

Clayton

Code could be written to iterate a folder but the simplest way would be to
select say files 1-20 and right click and select 'Open' from windows
explorer. Excel would open with those 20 files, you could view, save as and
then delete any you didn't want.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
D

Dave Peterson

There used to be a QuickView program (installed as an option in Win98 IIRC or
maybe it was part of TweakUI???).

It would let you right click on the file name in windows explorer and see the
contents of the first page of a word document or the first portion of the first
worksheet tab of an excel file.

I'm not sure it exists in newer versions of windows.
 
D

David McRitchie

Hi Clayton,
Before doing anything else like opening files in Excel,
I'd make sure I had a copy of all of the files.
http://www.mvps.org/dmcritchie/excel/backup.htm

Are the original file names intact in restored files, or do you
have a file that you know is an Excel file (or a Word file) but
you don't know what it is until you open it.

If you just want to rename files, and move files from one
directory to another you can rename the file external to Excel.

If the names are recognizable you move and rename them
before looking at them in Excel and then simply delete if
not wanted.

If you gave the name of the program that restored the data
that might help someone (not me) have a better idea of your
problem.

How do you think your problem would best be solved and
what do you need.
 
Top