08-20-2015, 11:37 PM
Also if you are creating excel object then u can code like this..
sheet.cells(i,j).value=4,5,etc.. to set values in cells
workbook.save
xl.quit ' to quit excel application
set xl = nothing ' to release memory
sheet.cells(i,j).value=4,5,etc.. to set values in cells
workbook.save
xl.quit ' to quit excel application
set xl = nothing ' to release memory