Can any one tell me swhy my code stops at Paratransit and gives me an
Expected end of statement error

ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Owner\Desktop\Worksheets("Paratransi t Names").[A1].Value "
_
& LWOP, Day Trade, Shift Swap.xlsm", FileFormat:= _
xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

Maybe...

ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Owner\Desktop\" _
& Worksheets("Paratransit Names").range("a1").value _
& "LWOP, Day Trade, Shift Swap.xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

"Patrick C. Simonds" wrote:

Can any one tell me swhy my code stops at Paratransit and gives me an
Expected end of statement error

ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Owner\Desktop\Worksheets("Paratransi t Names").[A1].Value "
_
& LWOP, Day Trade, Shift Swap.xlsm", FileFormat:= _
xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

--

Dave Peterson