How can i run this code?

[Bhaskara123]

Hi all,

I got one error that is
Run-time error '3126': Invalid bracketing of name '[Forms!Main!FromDate]'.

Code:

FileOut = FixName("SRMatrixCreatedByMonthMNS-" & Format(Forms!Main!FromDate.Value, "mmddyy") & "-" & Format(Forms!Main!ToDate.Value, "mmddyy") & ".xls")
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "SRMatrixCreatedByMonthMNS", TempLoc & FileOut, True
CopyMyFile TempLoc & FileOut, FinalLoc & FileOut
Kill TempLoc & FileOut

Could anyone help me. It would be very useful to me.

Thanks,
Bhaskar.

 

[boblarson]

Why are you using FixName (if using it, isn't there another parameter that tells it how many characters?)?