Transferspreadsheet: cannot export to .xlsm

[dlemos]

Hi all



I'm new to Access and I'm trying to export two tables to a .xlsm macro enabled workbook.


Here's the code:

Function Macro2()
On Error GoTo Macro2_Err

    DoCmd.TransferSpreadsheet acExport, 10, "Ass+Traf", CurrentProject.Path & "\queries.xlsm", True, "Sheet2"
    DoCmd.TransferSpreadsheet acExport, 10, "ParqueSet2010 p/ Gessica", CurrentProject.Path & "\queries.xlsm", True, "Sheet3"


Macro2_Exit:
    Exit Function

Macro2_Err:
    MsgBox Error$
    Resume Macro2_Exit


End Function

When I replace xlsm for xlsx it works fine, but in the above case I get the following error:

"Cannot update. Database is read-only".

I checked the file properties, and the read-only box is unchecked.

Does anyone know why this happens?

I need to export to a xlsm because I want to build excel macros in the destination file ("queries").

Thanks in advance

[ajetrumpet]

"Cannot update. Database is read-only".

I checked the file properties, and the read-only box is unchecked.

Does anyone know why this happens?

do you have the file open? xlsm's may not be valid file types for Access. If they're not, the workaround is to change your books to 97-2003 compatible. In those versions, there are no extra extensions for macro-enabled books.

ParqueSet2010 p/ Gessica

as a side note, you really should never include slashes in an object name. spaces are not the best either...

[dlemos]

I still have the xlsm problem but I can use the 97-2003 extension, it works just fine.thanks for the help