How do I pull data from excel to VB form

Where is the form?

form now attached. thanks StephenJR
WindowsApplication1.sln

VB classic or VB.Net?

VB classic, what would be difference. The way the data is stored?

I used this in the past, think it should work for you:

http://www.developerfusion.com/code/5322/working-with-excel-files-using-vb6/

What if I wanted to share this with multiple people. should it be .net and on a sql server. is there not a way to add the data to the application instead of storing in    xl.ActiveWorkbook.Close False, "c:\book1.xls"

when you say "share" you mean available for others to work with the application at the same time?

if so, yes a better way would be using vb.net and sql server.

btw, vb.net is easy to handle if you used vb classic before:)

I already have a sql server. do you have any smaple for what I am trying to do for .NET.

So I have a few question, IF this was setup on a sql server I can use the same form that I created? what would be needed to be on users computer to use it and will they maybe one day be able to edit the data is its not correct. that would be awesome!

Thats right it is Visiual Studio 2010

This thread is for vb classic and excel. For a vb.net and sql server you should create a new question.