how to create excel workbook project in visual studio 2005

Question

Hi friends I have installed visual studio 2005 I want to create excel workbook prject. Is it possible to create excel workbook project in visual studio 2005 ....... Thanks in advance...

santhosh · Answer

thank u .......

Bechir Bejaoui · Answer

Yes it is but first of all you have to download the office primary interop assemblies before here two links If you work with Office 2003 Click here If you work with Office 2007 Click here The last one is updated so it works with both 2003/2007 To install them follow the instructions To install Office primary interop assemblies In Control Panel  choose Add or Remove Programs . Select Microsoft Office in the Currently installed programs list. Click Change . Select Add or Remove Features  and then click Next . Select Choose advanced customization of applications  and then click Next . Expand Microsoft Office Excel  click the box next to .NET Programmability Support  and then click Run from My Computer . Expand Microsoft Office Outlook  click the box next to .NET Programmability Support  and then click Run from My Computer . Expand Microsoft Office Word  click the box next to .NET Programmability Support  and then click Run from My Computer . Expand Office Tools  click the box next to Microsoft Forms 2.0 .NET Programmability Support  and then click Run from My Computer . Under Office Tools  click the box next to Smart Tag .NET Programmability Support  and then click Run from My Computer . Under Office Tools  expand Microsoft Graph  click the box next to .NET Programmability Support  and then click Run from My Computer . Follow the same procedure to install primary interop assemblies for any other Office applications you want. Click Update . The primary interop assemblies are installed in the global assembly cache. You should include the Microsot.Office.interop.Excel using Microsoft.Office.interop.Excel; // for C# Imports Microsoft.Office.interop.Excel // for VB.NET to create a workbook use this code Excel.workbook myWorkbook = this.Application.workbooks.add(); To open an exisitng workbook this.Application.workbooks.Open(filename); To close a workbook this.Application.workbooks.Close(filename); To save an already existing workbook this.Application.workbooks.Save(filename);