Simply open excel

[ozav]

I just installed Visual Studio 2010
I want ONLY write code in order to use data stored in a excel file.
I just want to create a Form , open an excel file and browse it.
Should I create a pecial project ? Should In install something more than just Visual studio ? Should I declare or add any library ? what are the code instructions to be used ?

[westconn1]

see the tutorial in the faq thread at the top of this forum

yes you should start a new project, you would need a reference to excel, unless you use late binding
as long as excel is already installed you should not need to install any additionals

[ozav]

sorry, i didn't understand ... I started a new project, put a button in Form1 ans wrote some code on clicking the buutton
i used the code Workbooks.open("myexcelfile.xls") and i get error od workbooks. the system asks me to create the Workbooks class .....

[westconn1]

yes, you have to create an object of excel first, then the workbooks collection is a property of that object, on which you can use the open or add methods

did you look at the tutorial?

[ozav]

I didn't look at the tutorial, because I don't know which tutorial ...... You're so kind and I'm grateful, would you like to lead me with details ?

[westconn1]

i only use vb6 so i can not help with visual studio 2010, apart from basics, you need to research more, or wait till someone familiar with .net syntax reads the post