TransferSpreadsheet formatting with tic marks

nschroeder

nschroeder
Local time
Today, 16:33
Joined
Jan 8, 2007
Messages
186
I am exporting a query to a spreadsheet, and the resulting worksheet has tic marks at the beginning of each cell, including the headings, with the exception of one column that has a date. Is there any way to get rid of these? I tried experimenting with changing the AcSpreadSheetType from the default value, but it gave a "Named Argument Not Found" error.

Code:
Private Sub cbExport_Click()
    DoCmd.TransferSpreadsheet TransferType:=acExport, TableName:="qryEmployeeList", _ &
    FileName:=tbDestination.Value, HasFieldNames:=True
End Sub

Thanks for any help.
 

Users who are viewing this thread

Back
Top Bottom