[RESOLVED] Missing "Imports Excel"

[Mechy09]

Hi Guys!

I'm currently trying to import data from an Excel document to a list in Visual Basic 2010 Express. The Idea is to have the data easily modifiable by the users. I have looked quite a bit online and all of the examples seem to reference either an "Imports Microsoft.Office.Interop.Excel" or "Imports Excel". When I try to use the I get "(no correction suggestions)". I don't have any idea on how to fix this. Any suggestions on a solution would be greatly appreciated!

Thanks!

PS I have just started using Visual Basic last week and have almost no previous programming experience so any suggestions on resources where I could learn more would be awesome!

[DataMiser]

You have to add a reference using the project\add reference menu item

[klegrand]

You have to make a reference to the Microsoft.Office.Interop.Excel (find this on the .NET tab)
You can select Excel version depending on which version of Excel installed on your pc.

Wath out ! Excel needs to be installed on your pc.

Then in your code use : Imports Microsoft.Office.Interop.Excel

Hope this help,
Kurt

[Mechy09]

Thanks! That's exactly what I needed.