VB6 Beginner Needs Help Reading Excel into VB6 and Writing Back to VB6

[learningvb123]

I have about 400 rows of data in Excel. Each Row is a record set. I want to read each cell in each row into VB6 (one row at a time) and then do calculations on the cells in the same row and then rewrite them back to a new Excel file.

When my progam starts I'm able to assign (for example) A1 to a variable and B1 to a variable, and so on and can then do my calculations. But how do I make my program go to the next row (for example) A2, B2, C2....and then A3, B3, C3...so on, so i can run calculations on each successive row. And how will I let VB know I've reached end of last record?

Thank you for your assistance, any help will be greatly appreciated.

David

[vijaydiwakar]

I have about 400 rows of data in Excel. Each Row is a record set. I want to read each cell in each row into VB6 (one row at a time) and then do calculations on the cells in the same row and then rewrite them back to a new Excel file.

When my progam starts I'm able to assign (for example) A1 to a variable and B1 to a variable, and so on and can then do my calculations. But how do I make my program go to the next row (for example) A2, B2, C2....and then A3, B3, C3...so on, so i can run calculations on each successive row. And how will I let VB know I've reached end of last record?

Thank you for your assistance, any help will be greatly appreciated.

David

u connect to excel with the help of dsn then use select * from sheet1 range(A1:last right column)

try this or if not done then i'll give u d code but first try it
don't worry i've d sol