Editing Excel file

[eclipsed82]

Hey guys... I've been editing an already existent excel file through VBA in access. For some reason though, when I want to go see the changes and open up the xls file, I always get the messagebox saying the file is read-only and asks me if i want to read-only or notify or cancel.. Also, I'm using another Excel file that has data I need to read in order to edit the other excel file, but whenever I open that file as well, it says it's a Read-only.. These files didn't begin as read-only.. They only turned out to be after I run the code. Can someone tell me why this is happening and how to get rid of this??

 

[VBAjedi]

Code? I don't see any code. . . if you think that's what made your files read-only then we need to see it.

VBAjedi

 

[tbl]

If you are accessing a file with VBA from one Microsoft Office program to another it is very easy to forget to close the executable that is used to perform this as they are not always visible. Use Ctrl Alt Delete to see if there are more instances of Access and Excel running than you have visually open. Close the superfluous ones and see if that solves your Read-Only problem. If it does, go back to your code and close instances that you have opened with the code after they have been used.

Richard