+ Reply to Thread
Results 1 to 28 of 28

Cannot read 1004 error

  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Question Cannot read 1004 error

    I have created an Excel file (for distribution) but for some reason when I send to another PC this message appears.

    Microsoft Visual Basic
    Run-time error '1004':
    Cannot access read-only document 'smnsystem.xls'

    I do not know why this is appearing.

    Any assistance would be greatly appreciated.

    1004 read only.jpg

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Cannot read 1004 error

    I believe the user may be downloading the file from the email, sometimes files downloaded from email will be opened as read only so when the macro cannot able to run in the read only file. Is it so???


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    Quote Originally Posted by :) Sixthsense :) View Post
    I believe the user may be downloading the file from the email, sometimes files downloaded from email will be opened as read only so when the macro cannot able to run in the read only file. Is it so???
    yes that's exactly right. My file is download from an email I send.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Cannot read 1004 error

    Check with the user whether it's happening when the file is in read only. If the file is in read only then Top of the file name it show READ ONLY. Please check and confirm

  5. #5
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    Quote Originally Posted by :) Sixthsense :) View Post
    Check with the user whether it's happening when the file is in read only. If the file is in read only then Top of the file name it show READ ONLY. Please check and confirm
    Yes that's exactly right, the top states ' read only'.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Cannot read 1004 error

    Ask the user to save the file in local machine and try to open it instead of opening the file when downloading from mail.

  7. #7
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    Quote Originally Posted by :) Sixthsense :) View Post
    Ask the user to save the file in local machine and try to open it instead of opening the file when downloading from mail.

    Yes that has been done. I am doing this myself on another PC. Still does the same.

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Cannot read 1004 error

    Still the file is showing as read only or it is in editable mode?

  9. #9
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    Quote Originally Posted by 7Black View Post
    Yes that has been done. I am doing this myself on another PC. Still does the same.
    When I press 'End' the file will open, however, a formula is disabled at the top of the sheet showing #FALSE rendering the rest unusable. I cannot delete the cell or move the sum to a lower cell as the same result appears.

    The sum is: =D3+D4

    Scratching my head on this one.

    fails to sum.jpg

  10. #10
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    Once open shows as normal, though #FALSE showing. See above response.

  11. #11
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Cannot read 1004 error

    #Value error occurs when you perform calculation with text data and number like ="ABC"+55 will result #Value error.

    Instead of using + use Sum function which will ignore text data.

    Try like this...
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  12. #12
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    In the 'fails to sum' jpg above the grey cell showing $0.00 is actually a formula carrying a cell value from the previous page. If I manually enter a figure #FALSE is replaced by the summed amount as per math =D3+D4

    Are these two issues linked?

  13. #13
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    YOU ARE A CHAMPION!

    Thank you so very much that worked a treat! Awesome!!!!!

  14. #14
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Cannot read 1004 error

    Can you please share that formula. Because the formula may be resulting text output.

  15. #15
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    It is formatted to currency 2 decimal places.

    Thank you. You have assisted me previously Sixthsense.

  16. #16
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Cannot read 1004 error

    Glad you fixed it and thanks for the feedback

  17. #17
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    The #FALSE issue has been repaired though the '1004' error still shows.

  18. #18
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Cannot read 1004 error

    Can you please click the debug button and post the code on which line it's facing the error?

  19. #19
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    Quote Originally Posted by :) Sixthsense :) View Post
    Can you please click the debug button and post the code on which line it's facing the error?
    Unable to press debug button as it's greyed out. I can press 'end' or 'help'.

    1004 read only.jpg

  20. #20
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Cannot read 1004 error

    I believe the project is protected with password or the file will be in shared mode.

    Without seeing the error line of the code its hard to fix the issue

  21. #21
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    This makes it more confusing as there is no password associated with the file. Oh dear....

  22. #22
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Cannot read 1004 error

    I am not talking about file or sheet protection. It's about VBA code protection...

  23. #23
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Cannot read 1004 error

    Sixthsense is Champion. I know also he had helped me many time.

    regards,
    nandkumar satpute
    __________________________________________________________
    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

  24. #24
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Question Re: Cannot read 1004 error

    Quote Originally Posted by :) Sixthsense :) View Post
    I am not talking about file or sheet protection. It's about VBA code protection...

    So if it's about VBA code protection how do I go about removing it?

  25. #25
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Cannot read 1004 error

    To unprotect your code

    Open the Excel Workbook and press Alt+F11. Now, from within the VBE go to Tools>VBAProject Properties and supply the password

  26. #26
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    Quote Originally Posted by :) Sixthsense :) View Post
    To unprotect your code

    Open the Excel Workbook and press Alt+F11. Now, from within the VBE go to Tools>VBAProject Properties and supply the password
    thank you Sixthsense, however, I still get the same result when sent to another PC.

  27. #27
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Cannot read 1004 error

    I don't know you got my point or not I cannot suggest without seeing the code on which the error occurs.

  28. #28
    Registered User
    Join Date
    02-20-2013
    Location
    Adealide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Cannot read 1004 error

    Quote Originally Posted by :) Sixthsense :) View Post
    I don't know you got my point or not I cannot suggest without seeing the code on which the error occurs.
    Thank you for your assistance Sixthsense. For some reason this error occurs on one PC only so this may be an issue with that particular PC. All of your advice has aided in the resolution.

+ 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