TransferSpreadsheet error

[Bioman]

Somenone have an idea why this line cause an error???

DoCmd.TransferSpreadsheet (acExport,,"R_export_excel","d:\test.xls",,,)

Thanks!

 

[Drevlin]

get rid of the parenthesis

DoCmd.TransferSpreadsheet cExport,,"R_export_excel","d:\test.xls"

I'm not sure exactly why... but you only use parenthesis when you have an equals sign.

x = FunctionCall( a, b, c)
FunctionCall a, b, c