Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filesearch property (Excel 2003)

    I have a macro that uses the filesearch object to search though some directories and return a list of files matching some criteria. After a recent upgrade to our systems, this object no longer returns zip files when performing the search. All other files are OK, but zip files are ignored.

    Does anyone have any idea what is preventing the zip files from being found.

    Any help much appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filesearch property (Excel 2003)

    On Windowx XP, .zip files are not seen as files by FileSearch in Office XP and 2003. You may be able to use Dir instead; there are examples of Dir in this forum.

Posting Permissions

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