LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default File Extensions

Greetings !

OK, so my add-on hard drive is a tad screwed up - somehow my "My Pictures"
Folder has been converted into a file.

CHKDSK has been so kind(?) as to "recover" these "lost files", and name them
as FILE0001.CHK, etc. in folders called FOUND.000 etc.

As I understand it, some of those files are plain text files, so I could
simply rename those with the extension .txt

Well, that's not to difficult... ish !

I intend to get VBA to load up the first 64(?) characters of every file, and
compare these with those from the picture files I have back up, I can
eliminate those, leaving to be recovered only those files that I have omitted
to back up.

I have over fifty thousand .CHK file, in seven FOUND folders :(
That number will fit on one Excel WorkSheet.

If VBA checks that the first 64(?) characters are all between CHAR(32) and
CHAR(127), then (if they are), VBA can rename them with the .txt extension.

Now, using the incomparable and essential
-------------------------------------------------
LIST Version 6.4a 9/21/88
(c) Copyright Vernon D. Buerg 1983-88
139 White Oak Circle, Petaluma CA 94952
For personal use only. May not be sold.
-------------------------------------------------
it seems to me that
all .ZIP files seem to start with Hex(504B03) i.e. "PK"
all .PDF files seem to start with Hex(25504446) i.e. "%PDF"
all BitMap files (.BMP) seem to start with "BM"
all .TIF files seem to start with Hex(49492A) i.e. II*


So if SKS could
a) confirm that my logic is sound; and
b) advise me on how many characters I need to test; and
c) provide the information that is contained within
each file that identifies its type,

then I can rename the files with
the correct extensions and look at the contents !

Pretty please?

Or any other ideas - perhaps there is already
software "out there" that I could use ?

Others MUST have had this challenge before !

The Symantec help line couldn't (or wouldn't) advise.



Regards

Robin
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
don't want see file name with extensions. Rao Ratan Singh Excel Discussion (Misc queries) 7 March 14th 09 04:39 PM
File extensions colleen Excel Discussion (Misc queries) 3 September 16th 08 11:18 PM
File extensions Mex Excel Discussion (Misc queries) 5 August 4th 08 08:05 PM
file extensions dottiea Excel Discussion (Misc queries) 1 July 27th 06 04:16 PM
XML file extensions Rowan Excel Discussion (Misc queries) 2 April 22nd 05 07:54 AM


All times are GMT +1. The time now is 03:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"