+ Reply to Thread
Results 1 to 4 of 4

Runtime error '1004': cannot access...

  1. #1
    Registered User
    Join Date
    07-19-2010
    Location
    Winnipeg, Manitoba
    MS-Off Ver
    Excel 2003
    Posts
    2

    Runtime error '1004': cannot access...

    I'm getting an error stating that there is a "Runtime error '1004': cannot access '***.csv'. The window that this error is displaying in has the buttons "End" "Debug" and "Help". This is the code:

    Please Login or Register  to view this content.
    When the "Debug" button is clicked the error points to ActiveWorkbook.Save
    The user then has to shut down the macro and then rerun it. Is there any way to have it catch the error and retry?

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255

    Re: Runtime error '1004': cannot access...

    Hello rsford31,

    Welcome to the Forum!

    I suspect the error is occurring because the workbook has not been saved before. Has it?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    07-19-2010
    Location
    Winnipeg, Manitoba
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Runtime error '1004': cannot access...

    Thanks!

    I believe it has been saved. There is a csv file in that path on the server. What's happening is there is live data being fed into the csv file. The macro's job is to save the file every 3 seconds. But these errors pop up and the macro has to be restarted. The errors don't occur all the time either. They are sporadic.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255

    Re: Runtime error '1004': cannot access...

    Hello rsford31,

    It is a synchronization problem. Only one program at a time can have a file open. The error occurs when you try to close the file to save it and the query is still has the file open. Not really sure how to workaround that other than trapping the error and try again. Probably need to count the number of retries before aborting.

+ 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