Solved

How can I be sure that a MS Excel Object Library is available to my VB.net Application?

Posted on 2014-03-27
6
882 Views
Last Modified: 2014-03-28
I am converting my VB6 application to VB.net using Visual Studio 2013.  The VB6 application is heavily dependent on data imported from and exported to Microsoft Excel files.  My immediate issue is finding a successful method to transfer data from VB.net to Excel.  I used a Microsoft article,  http://support.microsoft.com/kb/301982 , “How to automate Microsoft Excel from Visual Basic .NET,” to develop an example application to transfer data to Excel.  

The VB application develops 17 errors, many of which are duplicates.  I infer from the errors that my required reference to the Microsoft Excel 15.0 Object Library has been unsuccessful.  I also believe there are several unidentified procedures required to make this example work.  I am a novice at using Visual Studio and VB.net so I really don’t have a clue of what to do next to get this example to work.

A sample of the errors follows:
'Imports' statements must precede any declarations.
'Excel.Application' is not defined.
'Excel.Workbook' is not defined.      
'Excel.Range' is not defined.
'Excel' is not declared. It may be inaccessible due to its protection level.
'Excel.Chart' is not defined.
'Excel.Series' is not defined.

Please let me know the best way to proceed in this effort.  I cannot see any evidence that the MS Excel Library is available to my application.  Is there a way to assure it is available?
0
Comment
Question by:Gene Lenning
  • 4
  • 2
6 Comments
 
LVL 26

Accepted Solution

by:
MacroShadow earned 500 total points
ID: 39960887
You have to add a reference.

Right-click on References in your project
Select Extensions on the left
Scroll the list for Microsoft.Office.Interop.Excel
Select it (checkmark)
Click OK
SnapShot
1
 

Author Comment

by:Gene Lenning
ID: 39961509
I had followed the instructions stated in my referenced Microsoft article and added the reference to Microsoft Excel 15.0 Object Library to my application using the method you suggested.  I have no indication the library is available to my application as you observed.  What would interfere with the availability of the reference and what can I do to overcome this problem?
0
 
LVL 26

Expert Comment

by:MacroShadow
ID: 39961615
Did you follow the steps in my post or only those in the MS article?
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:Gene Lenning
ID: 39961958
You solved my immediate issue on the references.  Thank you!  I didn't see the checkbox.  I followed your instructions and it did successfully add the reference to the MS Object Library as verified by observing the References via the project Properties display.

The sad part is that I still have the same 17 errors.
0
 

Author Comment

by:Gene Lenning
ID: 39962858
I've requested that this question be closed as follows:

Accepted answer: 0 points for Gene456's comment #a39961958

for the following reason:

The expert immediately provided the answer to my question however I missed the key, the checkbox.  Furthermore I could verify that the library was indeed added to the project reference list.
0
 

Author Closing Comment

by:Gene Lenning
ID: 39962859
Thank you for your help.  I did not see the checkbox required to select the needed library.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Adobe Customization Wizard XI issues 26 169
string initialization in java 11 103
count11 challenge 6 48
Dice Roll Probabilities 3 54
There is an easy way, in .NET, to centralize the treatment of all unexpected errors. First of all, instead of launching the application directly in a Form, you need first to write a Sub called Main, in a module. Then, set the Startup Object to th…
Having just graduated from college and entered the workforce, I don’t find myself always using the tools and programs I grew accustomed to over the past four years. However, there is one program I continually find myself reverting back to…R.   So …
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
This video teaches viewers about errors in exception handling.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now