I've managed to get my vb in SW to open an excel spreadsheet and create the next sequential number in a column.

The question is, how do I extract the new number that has been created in the spreadsheet and insert it into TextBox1?

Cheers,

Stevie.