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
VB Help If Statement in Selection.ShowDetail = True 5
Macro Help 4
Run Time Error on trying to save workbook 14
Saving file using data from worksheet 1
Prevent overwriting a file 4
Save Workbook with existing Name in the Folder 1

Top