I am using Excel Object Model however i am having difficulty in subtracting ColA-ColB = ColC. I want to write the difference of ColA and ColB in ColC and I have 10 rows. How can I do that? Can someone plese help? Thanks.
Seems to me you ask a lot of questions that can be answered by basic web searches.
Here's a hint on some help for your current crop of excel related questions
You can buy my Art from: "Post Cards now available"
Ian Fraser Landscape Photography
World Wide Shipping.
Thanks, This is really helpful.
Set objExcel = CreateObject("Excel.Application")
Set objExcelWb=objExcel.Workbooks.Open ("C:\Book123.xls")
objExcel.Visible = True
Set objWorksheet1 = objExcelWb.worksheets("Sheet1")
counter = 1
For Each R In objWorksheet1.UsedRange.Rows
tot = 0
For Each cel In R.Cells
tot = cel.Value - (tot)
R.Cells(counter, 3) =- tot
The issue what you have listed does not exist, works fine in my machine- stupid comment from the developer