Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    Michigan, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    scan for corrupt documents (97)

    Can anyone suggest a way to scan our file server for any corrupt Word or Excel documents?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: scan for corrupt documents (97)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Gregg

    OK define Corrupt and define scan?

    Are you thinking about looking for documents that don't work meaning will crash the system or hand the application or contain viruses?

    You can check for viruses by installing and running an antivirus protection program, my favorite would be ... Oh excuse me maybe I'll tell you in private lest me violate some Lounge rules.

    But to check for any other anomaly well we have to define that anomaly first.

    Hope this helps.

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Apr 2002
    Location
    Michigan, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: scan for corrupt documents (97)

    Perhaps the best way for me to define "corrupt" is to relate the background for why I'm even asking this question. One of our users recently tried to open an ancient excel document. I've been told that Excel 97 wouldn't open it - and gave the user a message that the spreadsheet was corrupt. It was at that point that I was brought into the problem so that I could blow the dust off of our backup tapes dating back to when the document was created.

    After this emergency was handled, my manager asked me if some utility was available to scan for other faulty Office documents on our system. Perhaps I could cobble together some macro that would traverse all our drives and try to open each word or excel document. However I'm lazy and would rather use a utility that someone else has already perfected.

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: scan for corrupt documents (97)

    Gregg

    You are on the right track, open and see which crashes and which works. But again run this macro at night after all have gone home because it is time consuming.

    The problem is, well when it crashes, it stops so you need someone to be there to restart the process. There are ways to bypass that, such as writing the file name to a worksheet or a text file and then place the workbook icon into your Windows Startup folder before you reboot and then the continue processing so now I can see how lazy you are, or how smart you are one of the other.

    But the surprise was that Excel 97 which should be backwards compatible could not open the workbook, that means the workbook is damaged and some how you can eliminate it from the pile.

    I know Office XP can do some new stuff with damaged workbooks I have not worked that much in XP but I hope you can trap that message that tells you to repair the workbook.

    HTH

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: scan for corrupt documents (97)

    Maybe she could use a macro in "Excel Session 1" that starts a *new* excel session using automation to load workbooks. It might just be possible to detect whether the session started through automation is still there (trying to access it will probably generate an error which can be trapped).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •