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.