[2005] VB.net write to Excel?

[Mark Douglas]

Ok, so try?

'xlSheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Row = Myname

?

Or replace my code with

.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Row = Myname ?

I don't really know where to place this portion?

Sorry, I'm still really new to all of this..

Mark

[Mark Douglas]

All right!! I've gotten it to find the last row used, set a counter and increment it by one to find the next available line to write to.

Now my final question I'm hoping someone can help me with and I'll be all done.

In the last row of information I have a job number stored in the first column. What I want to do is increment the number in the first column by one? Is it possible to get the information contained in a designated cell. Such as cell A6? I know how to string together the row, and "A" but not sure how to pull this from the excel file and store it as a variable?

Thanks for any help!!