I have a little VBscript that is gathering server info and exporting to excel Spreed sheet.
I want to save the Excel Spreed sheet as the name of the Server.
But I can not seam to get the wookbooks.saveas feature to work.
If I use excel.application.save it only save as book1.xls.
If I use excel.appplication.workboo
ks.saveas I get object doesn't support this property or method.
Hope someone knows the solution.
Excel_obj.workbooks.Saveas(FileDest_Str & "\" & ServerName_Str)
'Create Excel Spreedsheet
Set Excel_obj = CreateObject("Excel.Application")
Excel_obj.Visible = True