[RESOLVED] Office (excel) Import problem.

just downloaded a export dataset to excel project of codeproject.

While looking at the class the import line

Imports Microsoft.Office.Interop.Excel Code:

Imports Microsoft.Office.Interop.Excel

has a green squiggly line saying

Quote:

---

Warning 3 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\*\Downloads\Export\Export.vb 4 9 Export

---

in the middle of the class in a sub i have

The two other warnings include

Quote:

---

Warning 2 Cannot find wrapper assembly for type library "Microsoft.Office.Core". Export

---

Quote:

---

Warning 1 Cannot find wrapper assembly for type library "Excel". Export

---

how can i solve this

Solved!

WHat happened was that the path to the dll's for the office object library and office excel library were given the wrong paths. I had to re-reference them using the COM tab in "add references"

I had that happin to me as well masfenix, i had to apply the lastest excel update which fixed my issue.

ps, please mark resolved

Hi, i have the same error as the original poster, i am using probably the same code, too :D

I am at the COMS tab in add reference, but i cannot find anything relating to the "office object library and office excel library" that he mentioned.

Can anyone help? Thanks so much in advance!

Bump, need help, please. =/

http://img200.imageshack.us/img200/5954/nnni.jpg

Check the FAQ in the office forum.

Have you included the appropriate Microsoft.Office.Interop?

Hmm did you mean this line: Imports Microsoft.Office.Interop.Excel?
If so, yup i have it.
Also i don't know what he means by changing the paths to dll? I can't edit any of the line in that picture you linked.

If anyone was wondering i am trying to get http://www.codeproject.com/KB/vb/Sen...ware_Eng_.aspx
to work so as to implement data export in my own windows application :D

EDIT: I checked up the FAQ, they only have data export from SQL Server to Excel via ADO (I'm using VB.NET)

Have you actually included the Imports Microsoft.Office.Interop.Excel?
Just by adding that line didnt help me.

Check out Post #3 " .NET"

*edit
Do you have any of these in your debug folder?
http://img44.imageshack.us/img44/4332/debugd.jpg

If not download the appropriate PIA's for your version and add them to your project.
http://www.vbforums.com/showthread.php?t=422689

Ah yeah, i have none of those dll files, heh.
Thanks, I'll go try it out right now.
Also, if i am using Open Office 3.0, which PIAs should i be downloading?

And yeah i have that line in my codes already.

EDIT: I cannot find the Microsoft Office Excel, will i need MS Excel installed on my machine for this? Because i only have Open Office 3.0 Heh

That i am afraid i cannot help you with as i have excel.

Have a search for "Do you need excel to reference it" or something like that...