i want to store values in excel file using vb script in test complete

Short answer is to utilize the COM object of Excel (Sys.OleObject('Excel.Application')) and interact with the excel files that way.

 

Read https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sources/excel/working-via-com.html for more information.