Expected end of statement error

  • Thread starter Thread starter Patrick C. Simonds
  • Start date Start date
P

Patrick C. Simonds

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("Paratransit 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 said:
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("Paratransit Names").[A1].Value "
_
& LWOP, Day Trade, Shift Swap.xlsm", FileFormat:= _
xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Click to expand...
 
Back
Top