ExcelBanter - Expected end of statement error

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Expected end of statement error (https://www.excelbanter.com/excel-programming/415699-expected-end-statement-error.html)

Expected end of statement error

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

Expected end of statement error

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