Printable View
Can someone do a quick test as there seems to be a bug I think?
open a new project using vb.net, now you have form1. Add the reference to excel 9.0
in a button click event you can type dim oexcel as new excel.application
this works fine.
Now delete form1 and add a new form. This time do the same as above. i.e. in the click event place the same code.
Do you get an error? if so why?
Thanks
What is the error you are getting??
The error is excel.application is not defined
As if there is noreference to the excel library. But there is.
This is very strange and I can not figure it out why it is happening.
What VS.NET version you are talking about ?
This is not a bug. Whenever you add a new reference to your project, you have to place a using or imports statement at the top of the form you want to use that reference in. So if you added a reference to the using Microsoft.Office.Core object, at the top of the form, you would put imports using Microsoft.Office.Core or you can just use the fully qualified name.
currently there is a reference to excel but there is no imports microsoft.office.core on the top. And it still works
??
I did'nt mean 'that' reference. That was just an example.
Yes , it can still work . Imports and using (in C#) is not important . It's only a way to shorten function call or sub .Quote:
Originally posted by fmardani
currently there is a reference to excel but there is no imports microsoft.office.core on the top. And it still works
??