Posted: 1/16/2012
Dear All,
I am writing code in the Script component in VB.NET (Business Intelligence Development Studio)
I typed Imports Microsoft.Office.Interop.Excel
But Intellisense does not recognize anything after Microsoft. A green squiggly appears under the statement.
The tool tip says, "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." I downloaded, unblocked and installed the Office 2003 PIA's and also Add Reference->COM->Microsoft Office 11 Library Object but I still get the same result. Is this another trick, or have I missed something?
Please help me.
Thanks and regards-
bsingha