+ Reply to Thread
Results 1 to 5 of 5

Test if file exists even if hidden

  1. #1
    Forum Contributor
    Join Date
    08-23-2010
    Location
    Staten Island, NY
    MS-Off Ver
    Excel 2003
    Posts
    242

    Test if file exists even if hidden

    I am using this Function to test if files exist in many cases. It has always worked for me in the past but now it will not work on Hidden files (I never used it on hidden files in the past).

    Please Login or Register  to view this content.
    Is there a way I can modify this so it works on both Hidden and Visible files within Hidden or Visible folders?

  2. #2
    Forum Contributor
    Join Date
    08-23-2010
    Location
    Staten Island, NY
    MS-Off Ver
    Excel 2003
    Posts
    242

    Re: Test if file exists even if hidden

    anybody have any ideas?

  3. #3
    Forum Contributor
    Join Date
    08-23-2010
    Location
    Staten Island, NY
    MS-Off Ver
    Excel 2003
    Posts
    242

    Re: Test if file exists even if hidden

    Please? the code works except when files are hidden. How can i get it to find the file even if it is hidden?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Test if file exists even if hidden

    Have you tried the vbHidden attribute?

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Contributor
    Join Date
    08-23-2010
    Location
    Staten Island, NY
    MS-Off Ver
    Excel 2003
    Posts
    242

    Re: Test if file exists even if hidden

    Andy you are the man - that fixed it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1