Expected end of statement error

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
 
D

Dave Peterson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Path and FileName 2
Code Fails on SAVE 4
chart name not saved when save as another file 0
VB Help If Statement in Selection.ShowDetail = True 5
Run Time Error on trying to save workbook 14
VBA - exporting serial letters to single documents 0
run time error 1004 2
Save Workbook with existing Name in the Folder 3

Top