In case anyone was wondering, I got this code below to work from the help of this post here.
Now I just have to get back to figuring out the Permissions problem without having to uncheck Anonymous Authentication
<%@ Language = "VBScript" %>
Response.Buffer = True
Dim xlObject, xlBook, xlBookPath, wks
Set xlObject = CreateObject("Excel.Application")
xlObject.visible = False
xlBookPath = "C:\Inetpub\wwwroot\espinc\excel\NewHires.xls"
Set xlBook = xlObject.Workbooks.open(xlBookPath)
Set wks = xlObject.ActiveWorkBook.Worksheets(1)
wks.Cells(2, 1) = "Shane"
wks.Cells(2, 2) = "Jackson"
Set wks = Nothing
Set xlBook = Nothing
Set xlObject = Nothing