Hey Folks,
i have a problem with my query export to excel. my code is:
i set the format for numbers in the query to: #.##0;(#.##0)Code:Private Sub Befehl1_Click() DoCmd.TransferSpreadsheet acExport, 8, "Umsatz_Netto", "C:\Abfrage.xls" _ , True, "Umsatz_Netto" End Sub
but access does not get the right format the excel sheet is wrong. the format is not correct.
dou you have any ideas? how could i write the vba code?
thanks
Dev82