Error in VBA code
Compile Error:
Syntax Error
the above error is coming for the below code . it happens when inject the Day condition
Private Sub TestFileExistence()
If FileFolderExists("\\cf3.pepsico.pvt\psra\Output\BI 4\Exec Dollars - Current Period.pdf")and
weekday(date) = 2 Then
Range("A1").Value = "X"
Else
Range("A1").Value = "!"
End If
End Sub
|