| || |
using formula in the vbscript for excel
how to use formula in the vbscript for excel applicaton. ex
For i = 1 to 100
inc = inc + 10
inc1 = inc1 + 5
objsheet.cells(i,1).value = inc
objsheet.cells(i,2).value = inc1
objsheet.cells(i,3).value = ((objsheet.cells(i,1).value +objsheet.cells(i,2))
Here i want to use 'SUM' formula to add instead of mentioning the cell address
Re: using formula in the vbscript for excel
Refer to the attachment in the header of this post.
This VBscript uses formulas. Refer to the "WriteSpreadSheet" subroutine.