yes i know... resurrecting a dead thread!
i feel like im soo close here but i keep getting compiler errors, either object required errors or expected end function error
Function ExportWFormatting()
nme = Format(Now, "mmddhhnnss")
DoCmd.TransferSpreadsheet acExport...