"Type mismtach error" using DoCmd.TransferSpreadsheet

[Harry-Wishes]

Hello, I am trying to export a table from Access 2003 into an Excel 2003
spreadsheet. When Access runs into the line below, I get a type mismatch
error. I've looked at the syntax nearly a dozen times but can't find the
problem. Can anyone help me figure this out? It's probably obvious but I
certainly can't see it.

The table I want to export out of Access is named "Markers" and the name of
the Excel file I want to import this table into is bnf-data.xls in this
particular example below.

Harry-Wishes


DoCmd.TransferSpreadsheet acExport, "acSpreadsheetTypeExcel9", _
"Markers", "E:\bnf-data.xls", True

 

[Dirk Goldgar]

Hello, I am trying to export a table from Access 2003 into an Excel 2003
spreadsheet. When Access runs into the line below, I get a type mismatch
error. I've looked at the syntax nearly a dozen times but can't find the
problem. Can anyone help me figure this out? It's probably obvious but I
certainly can't see it.

The table I want to export out of Access is named "Markers" and the name
of
the Excel file I want to import this table into is bnf-data.xls in this
particular example below.

Harry-Wishes


DoCmd.TransferSpreadsheet acExport, "acSpreadsheetTypeExcel9", _
"Markers", "E:\bnf-data.xls", True

The defined constant, acSpreadsheetTypeExcel9, should not be in quotes. Try
this:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"Markers", "E:\bnf-data.xls", True

 

[Harry-Wishes]

Yeap. I already caught it. My eyes just saw those quotes.
Thanks

Harry Wishes