Consulting

Results 1 to 2 of 2

Thread: Make file read/write

  1. #1
    VBAX Tutor
    Joined
    Dec 2006
    Posts
    271
    Location

    Make file read/write

    Hi All,
    I have nearly finished my project which I would not have been able to do without the help of members on here - XLD I'm looking at you!
    I am at the point of sending it out for testing and review but have come across a small problem
    The file will be distributed on CD and when the users copy it to their machines it becomes Read Only.
    Their system will not allow them to change the properties of the file, therfore is there any code that when run will when opening the workbook and will:
    • check if file is read only
    • If file is 'read only' then make it 'read write'
    • If file is already 'read write' then do nothing

  2. #2
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    Usually after you have the file off CD you merely need to SaveAs a different name and it usually saves as full access!, so in your workbooks open you could save the file as a new name and set whatever access you want then Kill the original workbook.
    Regards,
    Simon
    Please read this before cross posting!
    In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
    If I have seen further it is by standing on the shoulders of giants.
    Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •