To add reference of Microsoft.Office.Interop.Excel.dll in Script Task,Visual Studio 2005 doesnot provide a COM tab to browse and get the dll.
Workaround : Place the Interop dll in Microsoft .Net folder(Usually C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727), it will appear in the .Net tab in Add reference of Script Task. Also, register this dll using Regasm command. 12.0 version of this dll is compatible with VS2005.
No comments:
Post a Comment