How do I open an existing Excel spreadsheet through Access that is NOT read-only?

[JackieEVSC]

I created an Excel file that users will copy to the root of C:. The reasoning behind having them use one on their local drive is so they can work on their own spreadsheet. I want the users to be able to click a button to open this file, then scan device asset tags to the spreadsheet, save it and exit. Another button will delete the existing tbl_AssetTags, import the spreadsheet file as the a new tbl_AssetTabs (a local, not linked table), and produce a report with asset and serial number tags. The code I am using to access the spreadsheet opens it as read-only. The code I'm using is: Dim stAppName As String stAppName = "excel.exe \\netappb\Administration\InfoSys\Netbooks\CreateTa gsByAssetNums.xlsx" Shell stAppName, vbNormalFocus How do I open an existing Excel spreadsheet through Access that is NOT read-only?

[June7]

I tested the Shell code and file opens in editable mode.

What are the permission settings for the file and/or folders?

[Micron]

In addition to June's idea, the read only property can be set on the file's property sheet, which is not dependent on the file or folder permissions. Right click on the file in Windows Explorer and see if the read only property checkbox is checked. I see that you are not using an Excel extension that is read only by default (such as xlt), so that should not be the issue. Test the permissions by trying to open the file directly. If the user can, permissions are not the issue if they are using your database under their own login credentials.

The other thought I had is that I'm used to seeing the call surrounded by () and in some cases, extra quotes. Don't know why, but I suggest trying that if the other suggestions don't help. E.g. Shell """C:\....\MSACCESS.exe C:\Yourdb.mdb /Excl /x mcrStartup""" or Shell ("C:\....\MSACCESS.exe C:\Yourdb.mdb /Excl /x mcrStartup")