i am opening the query in access and exporting it to existing worksheet within the existing excel file ,as in below code

Private Sub Command59_Click()

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "queryname", "pathname", , "worksheetname"


End Sub
------------------------------------------------------------

the above code when run says "cannot update.database or object is read-only "

can u help me wit this please....

supreeth

help...

supreeth

Hi supreeth

The only thing I can see that would stop this from exporting is that you have a names range going into the export file. If this export file is a workbook that already exists, it may be that it is already open, which means you cannot export to it. Try exporting without the the worksheet name, see if this work first.

Tell them they will hear,
Show them they will see,
Let them experience and they will learn