excel .net

[fmardani]

Hi,
Currently I have an excel macro which loops through each row of an excel sheet and does several tasks...
I would like to have the same thing in my vb.net application

Can you see if you can make the right changes so that it will work in the vb.net?

For Each KeyRow In Worksheets(1).Rows
If Len(Cells(intRow, 1)) > 0 Then
'Do tasks...
End If
Next

Thanks

 

[groston]

What exactly are you asking: The latest release of Excel (XP/2002) uses VBA, which is not the same as .NET.



----

Gerry Roston
gerry@pairofdocs.net

 

[kcj402003]

You need to add the Excel and Office COM references to your project.
This should expose all the methods and properties you need.