Scripting...

Currently working on a script that pastes print queues into and Excel sheet, then saves the sheet as the current date. Seems to work the excel part fine, but errors when saving.

Here is what I have:

objExcel.ActiveWorkBook.SaveAs _
"File location" & Format (Date, "YYYYMMDD") & ".xls"
objExcel.ActiveWorkBook.Close

Seems to error on 'Format'

I will post my findings once I figure out what the problem is