Overcome SAVE AS box in SAP while transferring the report to excel.

Application.DisplayAlerts = False 'IT WORKS TO DISABLE ALERT PROMPT

Dim AJ As Workbook
YOUR CODE

Application.DisplayAlerts = True 'RESETS DISPLAY ALERTS

End Sub

OR

ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\sin21757\Desktop\SAP\" & Range("a3") & ".xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False
ActiveWorkbook.saved = true
ActiveWindow.Close