+ Reply to Thread
Results 1 to 3 of 3

Kill command & Path/File access error (Error 75)

  1. #1
    Registered User
    Join Date
    08-27-2012
    Location
    Saldanha, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    59

    Kill command & Path/File access error (Error 75)

    I'm trying to periodically delete some old files with the following code. I get a Path/File access error (Error 75) and I've got no idea why, I checked the path and everything seems fine to me. I'm able to manually delete the files, so I don't believe it's anything to do with rights. Any help will be much appreciated!

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    08-27-2012
    Location
    Saldanha, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Kill command & Path/File access error (Error 75)

    Anybody any idea?

  3. #3
    Registered User
    Join Date
    06-29-2011
    Location
    Fort Lauderdale
    MS-Off Ver
    Excel 2018
    Posts
    24

    Re: Kill command & Path/File access error (Error 75)

    before your kill test it out to see if you are really getting what you think you want to kill:

    msgbox dir(killF(1))
    msgbox dir(killF(2))

    if you don't get at least 1 return for each then something is not working with the naming convention in the way you are thinking. Otherwise, you are correct, wildcards work with the kill as long as there are files to kill.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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