VBA Name write InUse_YES.txt to a folder using Const FileControlFolder

  • [xpost][/xpost]

    Morning All,


    First time user first time question.


    I have a workbook where when a user opens it the code below should write over InUse_No.txt to InUse_YES.txt


    Name FileControlFolder & FileControlSubFolder & "\InUse_NO.txt" As FileControlFolder & FileControlSubFolder & "\InUse_YES.txt"


    I use:

    Option Explicit

    Const FileControlFolder = "H:\PROJECT-OPS\MultipleUsersIssue\FilesInUse\"

    Dim FileControlSubFolder As String


    Which predefines the folder where FilesInUse is


    There is already InUse_NO.txt already in the folder FilesInUse but when I open it there is an error Run-time error 53 File not found - Which quite annoying!


    I attach 2 workbooks with simular code. I was mucking around to see if Im missing something but no avail


    Steven Behr

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!