Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email Syntax error
Hello from Steved
On the below line I'm receivinfg a compile error Syntax error ",_ Would somebody be kind enough to point out to me please what is it that I'm not getting right. Thankyou. Sub Mail_Todepot() Dim wb As Workbook Dim strdate As String strdate = Format(Now, "dd-mm-yy") Application.ScreenUpdating = False Sheets("To Depot").Copy ActiveSheet.Copy Cells.Copy Cells.PasteSpecial xlPasteValues Cells(1).Select Worksheets(1).Select Application.CutCopyMode = False Set wb = ActiveWorkbook With wb .SaveAs "C:/To Depots/Kilometres.xls" ",_ "Kilometres Per Bus" .ChangeFileAccessxlReadOnly Kill.FullName .Close False End With Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Syntax Error help | Excel Programming | |||
Syntax error Q | Excel Programming | |||
Syntax error. | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming | |||
Where is my syntax error? | Excel Programming |