No experience here,

but if you google "excel vba saveas worksheet" and find some VBA code like
    
    
    With ActiveWorkbook
        .SaveAs "C:\" & .Sheets(1).Name
        .Close 0
    End With
    

then you should be able to do something like
    
    
    obj.activeSheet.saveAs("insert the new name here :-)")
    obj.activeSheet.close(0)
    

Reply via email to