Appending existing excel worksheet through vb.net
Posted on 2004-11-29
Hey, I have an existing spreadsheet that we currently update manually. I'd like to write a program (VB.Net) that will update that spreadsheet automatically by a user selecting a few things from a list box and adding some text in textboxes.
My question is: How do I correlate certain objects to the next available columns/rows? Like right now we are on Row 185 and use through Column K for data. If someone inputs their stuff in my program, how can I be sure that it is going to the next available row and each object is going to the column it is supposed to. I'm new to all this....