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.
Thanks for any help.
Code:
Private Sub cbExport_Click()
DoCmd.TransferSpreadsheet TransferType:=acExport, TableName:="qryEmployeeList", _ &
FileName:=tbDestination.Value, HasFieldNames:=True
End Sub
Thanks for any help.