• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 406
  • Last Modified:

VB.NET reference file (EXCEL)

Where is the reference file located in order to read an excel file in VB.NET?
0
SynapcoCanada
Asked:
SynapcoCanada
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Microsoft Excel {Your Version} Object Library

C:\Program Files\Microsoft Office\Office\EXCEL{Your Version}.olb

Office may be Office11 or Office12, depending on your version

9 = Excel 2000
10 = Excel XP/2002
11 = Excel 2003

Hope this helps.
-Jim
0
 
bruintjeCommented:
Hi SynapcoCanada,
----------

depends on what you need

this is ADO.NET
http://www.experts-exchange.com/Q_20972338.html

this is using Interop
http://uk.builder.com/0,39026540,39285438,00.htm

if you use COM interop as in the last sample you need to reference Excel in the COM Tab of your project references

----------
bruintje
share what you know, learn what you don't
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now