none
Run time error 75/ path file access error RRS feed

  • Question

  • hello Developers!

    I am encountering this issue on my code: Run time Error 75 path/file Access Error. This is actually a part of a larger set of code that aims to create a file after entering data in an input box. per my online research, its an access issue which i dont think is an issue because i can read and write on that folder where the file saves. 

    When I click debug, its highlighting on this area: 

        Open File For Output As aOutput

    Appreciate the inputs in advance! 

    'Open output file for writing
        aOutput = FreeFile
        aFile = "C:\Users\TTLE\Desktop\OMAX\SUV_ZED.csv"
        Open File For Output As aOutput

    Thursday, April 19, 2018 11:28 PM

Answers

  • The variable containing the file path and name is aFile, not File, so you should use

        Open aFile For Output As aOutput


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by IamJackie Friday, April 20, 2018 3:05 PM
    Friday, April 20, 2018 8:09 AM

All replies

  • The variable containing the file path and name is aFile, not File, so you should use

        Open aFile For Output As aOutput


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by IamJackie Friday, April 20, 2018 3:05 PM
    Friday, April 20, 2018 8:09 AM
  • Geez! You took away hours of frustration! Thanks so much! Worked like a charm! 
    Friday, April 20, 2018 3:05 PM