+ Reply to Thread
Page 1 of 3 1 2 3 LastLast
Results 1 to 15 of 45

[SOLVED] Run time error 75 (Path/File Access Error)

  1. #1
    Registered User
    Join Date
    09-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    43

    [SOLVED] Run time error 75 (Path/File Access Error)

    This worksheet uses an OnTime event to check for the presence of an text file every 8 seconds and then read in the contents. I've checked everthing but can't figure out why it's crashing on my XP laptop but works fine on Win7. I just get a message saying excel needed to close...

    I've checked all the code to look for obvious signs of a memory leak but can't find any objects I'm not destroying properly. I checked memory usage on task manager and it does increase a little over time but the crash happens way before any memory gets used up.

    Bpth machines are running Office 2007 Home & Student. The XP Machine is a little Sony Vaio notebook with a 1.06 ghz processor and 1GB RAM whereas the Win7 laptop is a much faster beast, although nothing is telling me its a performance issue. On the notebook I use tuneup utilities to get it running pretty well.

    On Opening you have to click the Live Score option to start the timer. Before that the path on Settings B28/B29 needs to be any valid folder on your machine. It just looks for the presence of a file called score.flg and takes no further action if it can't find it.

    If anyone could take a look and offer some advice I'd really appreciate it.
    Attached Files Attached Files
    Last edited by Riggers; 03-05-2012 at 03:37 PM. Reason: Thread title typo.

  2. #2
    Registered User
    Join Date
    09-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: OnTime - Crashes on XP ok on Win7

    I should also say the crash happens even when there is no file found by the code called by the timer so the code which would open and read in the file is not even being called.

  3. #3
    Registered User
    Join Date
    09-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: OnTime - Crashes on XP ok on Win7

    I've done some more troubleshooting on this and I now think the problem is related to the display of one of the user forms. I'm seeing an intermittant problem whereby it displays File/Path Access Error and you are unable to bring the form up in VB editor. Closing the worksheet and reopening fixes it but eventually the problem comes back. The file is being launched from the desktop, not a network share or anything and I can't think of any reason for this strange message. Google hasn't been much help either. Anyone have any ideas why this could be happening?

  4. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,643

    Re: OnTime - Crashes on XP ok on Win7

    I don't see any checking of any file in the .ontime macro.
    It only contains 'calculate'



  5. #5
    Registered User
    Join Date
    09-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: OnTime - Crashes on XP ok on Win7

    After a lot more investigating I've now found this is nothing to do with the ontime routine. It's a little known bug affecting Excel 2007 workbooks containing user forms. After being open for a while the workbook generates a Run Time Error 75 (Path/File Access Error). Shortly after this the workbook would crash. My code was failing because the ontime routine was saving the workbook periodically and any attempt to save the workbook after the path/file access error instantly causes the workbook to crash.

    The problem seems to be specific to Excel 2007 and I've found one affected user suggesting an upgrade to 2010 fixed it for them. Most people affected seem to say it only happens on XP (me included) but worryingly someone has also reported it on Win7.

    There is no known fix for Excel 2007 users. Someone advised you could hide user forms instead of unloading them but that didn't work for me. I've tried everything to make it work but am finally giving up. I'll change the thread title to better reflect the issue.

  6. #6
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Run time error 75 (Path/File Access Error)

    Where is the evidence that this is a bug, rather than a code error?
    Good luck.

  7. #7
    Registered User
    Join Date
    09-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Run time error 75 (Path/File Access Error)

    Here is a link to the best thread I found on the subject:

    http://www.pcreview.co.uk/forums/use...-t3944734.html

  8. #8
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Run time error 75 (Path/File Access Error)

    That was a trial version of Excel 2007. Hardly definitive evidence of an ongoing bug.

  9. #9
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Run time error 75 (Path/File Access Error)

    FWIW though, for any intermittent code errors, I would generally recommend cleaning your workbook (using Code Cleaner) or even rebuilding it in a new workbook.

  10. #10
    Registered User
    Join Date
    09-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Run time error 75 (Path/File Access Error)

    Quote Originally Posted by OnErrorGoto0 View Post
    That was a trial version of Excel 2007. Hardly definitive evidence of an ongoing bug.
    Personally I think the evidence is pretty good. In that thread instructions were given as to how to recreate the problem in a new workbook and another user was able to do exactly that. I've already tried recreating my workbook myself from a new workbook and new user forms and the problem is still there. In all my research on the Run Time 75 Path/File Access error over the last few days all I have found is confusion and frustration from people and no fixes being found by any of them.

  11. #11
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Run time error 75 (Path/File Access Error)

    You've shown a few people experiencing an intermittent issue, but you yourself have it working in Excel 2007 on a different machine, which would imply to me that if there is a bug, it is not necessarily in 2007. It may be an issue with the OS, or a hardware conflict.

    Don't get me wrong - Excel 2007 is a buggy piece of **** in my opinion and I try never to use it, but I am not convinced that that is where this bug lies. (I note the coincidence of one user in that thread mentioning the error occurring after his screensaver kicked in for instance)

  12. #12
    Registered User
    Join Date
    09-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Run time error 75 (Path/File Access Error)

    Quote Originally Posted by OnErrorGoto0 View Post
    You've shown a few people experiencing an intermittent issue, but you yourself have it working in Excel 2007 on a different machine, which would imply to me that if there is a bug, it is not necessarily in 2007. It may be an issue with the OS, or a hardware conflict.

    Don't get me wrong - Excel 2007 is a buggy piece of **** in my opinion and I try never to use it, but I am not convinced that that is where this bug lies. (I note the coincidence of one user in that thread mentioning the error occurring after his screensaver kicked in for instance)
    I think we will have to agree to disagree on this. In my opinion this is a bug that's been found in Excel - they (different users) even recreated it with a simple new workbook with one form and one line of code. If a hardware conflict or an OS issue is causing Excel to do this (which I personally think is unlikely) then it is still a bug in Excel in my mind.

    More to the point - can anyone offer any suggested fixes other than those already mentioned?

  13. #13
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Run time error 75 (Path/File Access Error)

    It's more likely to be a bug in the Forms Library (FM20.dll) which is not actually part of Excel, I would suggest, but never mind. If it's not related to OS or hardware, why does it work on one of your machines?

    The only other thing I can suggest that you might try is not using the default instancing of the forms - declare a variable and use that, then destroy the variable when done.

  14. #14
    Registered User
    Join Date
    09-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Run time error 75 (Path/File Access Error)

    Quote Originally Posted by OnErrorGoto0 View Post
    It's more likely to be a bug in the Forms Library (FM20.dll) which is not actually part of Excel, I would suggest, but never mind. If it's not related to OS or hardware, why does it work on one of your machines?

    The only other thing I can suggest that you might try is not using the default instancing of the forms - declare a variable and use that, then destroy the variable when done.
    I'm not saying it's not related to OS or Hardware, I'm just saying Excel seems to behave differently on a Win7 machine to an XP machine, but I still say this is a bug in Excel. Anyway, that's just pedantics really.

    Thanks for the suggestion. I tried creating a new instance of the form then destroying it afterwards, I even tried not loading any of the forms at all (commented out all lines with .show) but the very fact the forms exist in the workbook seems to be enough to crash it.

    When I get home tonight I'm going to try and recreate the simple workbook and single userform described by those other users to see if that errors too, although I'm not sure what extra knowledge that is going give me. I've tried repairing Excel too. I hate to be beaten but it looks like I have been on this occassion.

  15. #15
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Run time error 75 (Path/File Access Error)

    I'm not saying it's not related to OS or Hardware
    Quote Originally Posted by Riggers View Post
    If a hardware conflict or an OS issue is causing Excel to do this (which I personally think is unlikely)
    Did I misunderstand that then?

    the very fact the forms exist in the workbook seems to be enough to crash it
    That would appear to be a whole new issue, or were you testing this in the same session where you had already shown the form(s)?

    Also, just to check, when you say "I tried creating a new instance of the form then destroying it afterwards", can you specify the code you used, please?

    If you can show this to be a replicable bug (a demo workbook would be ideal) under a specific OS, then I will file it as a bug, though I cannot make any promises that MS will pay attention.

+ Reply to Thread
Page 1 of 3 1 2 3 LastLast

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