Thank you for the help James. My script is a real basic model I exported from Model Builder as a python script.
# Import arcpy module
import arcpy
# Local variables:
SpecialEvents = "SpecialEvents\\SpecialEvents"
SE_Test_xls = "I:\\Documents\\SE_Test.xls"
# Process: Table To Excel
arcpy.TableToExcel_conversion(SpecialEvents, SE_Test_xls, "NAME", "CODE")
I have replied to Jake's response with what I am trying based on his comment, but don't believe I am doing it right.