Imports excel = microsoft.office.interop.excel is not working

Question

1.00/5 (1 vote)

See more:

Hello,

I am new to VB and have been trying to create a small app using excel. I went to the Microsoft support page and followed the instructions to add a reference to Excel 15.0 that is installed on my computer and then insert at the top of my Form1 the following "Imports Excel = Microsoft.Office.Interop.Excel" and the "Excel = Microsoft.Office.Interop.Excel" portion is underlined by the editor with no recommended solution. Do I need to upgrade my Visual Studio 2013 or install any add-ons? Any advice is greatly appreciated!

Here is the error I get when attempting to run the code

Warning	1	Namespace or type specified in the Imports 'Microsoft.Office.Interop.Excel' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases. C:\Users\Philip\Documents\Visual Studio 2013\Projects\Excel projects\VBdotNetSetup 5-26-17\VBdotNetSetup 5-26-17\Form1.vb	4	9	VBdotNetSetup 5-26-17

What I have tried:

I have tried searching the Microsoft support pages and have had no luck.

Posted 26-May-17 5:55am

Member 13197019

Updated 4-Jun-17 9:47am

v2

Add a Solution

Comments

[no name] 26-May-17 12:14pm

What does the error message (the most important information you should have included) say?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Phoeniques · Accepted Answer · 2017-06-04T09:47:00

Solution 3

If you go to:

Visual Studio -> Main Menu -> Project -> Add Reference

Choose to see the COM objects, and if you have Microsoft Office installed, you should be able to scroll down to:

Microsoft Excel [xx.x] object library

After that, your IMPORTS declaration should work.

Posted 4-Jun-17 9:47am

Phoeniques

Comments

Member 13895643 2-Jul-18 17:50pm

That worked for me - thank you!