Shared addin for excel 2003, Can we add button on excel sheet

[jesusdiehard]

hi guys,

this is first posting on The Scripts network.
Guys,
i have built a shared addin for Excel 2003 using visual studio 2005 and C#. Till adding command bar and menu items, it was okay.

But now i want to add typical button on excel sheet programmaticall y, but nothing seems to working.
Is it possible that i can add typical button controls on excel sheet from program.

[SammyB]

Should be possible. Here's how I did it in Excel VBA:

Sub aBook()
'This Macro creates a workbook, a button, and a code module
Dim wb As Workbook
Dim ws As Worksheet
Dim s As Variant
Dim btn As OLEObject
Dim lLines As Long
' Hide VBE Window = No screen flashes
    Application.VBE.MainWindow.Visible = False
' Create a new Workbook with one worksheet, Cmds
    Set wb = Workbooks.Add
    Set ws = Worksheets.Add
    ws.Name = "Cmds"
    Application.DisplayAlerts = False
    For Each s In wb.Worksheets ' Delete the rest of the worksheets
        If s.Name <> "Cmds" Then s.Delete
    Next s
    Application.DisplayAlerts = True
 
' Create a button
    Set btn = ws.OLEObjects.Add(ClassType:="Forms.CommandButton.1", _
                Left:=50, Top:=25, Width:=75, Height:=20)
    btn.Name = "cmdWork"
    btn.Object.Caption = "Press"
 
' Find the associated code module and create the click event handler
    For Each s In wb.VBProject.VBComponents
        If s.Name = ws.CodeName Then
            With s.CodeModule
                lLines = .CountOfLines
                .InsertLines lLines + 1, "Sub cmdWork_Click()"
                .InsertLines lLines + 2, "    MsgBox ""Back to Work!"""
                .InsertLines lLines + 3, "End Sub"
            End With
            Exit For
        End If
    Next s
End Sub

Obviously, you have some translation to do.

But, I have had a lot of trouble trying to do the stuff you have already done. Can you outline the steps to creating the Addin with C# 2005? I want to add a dialog box. I could do it with VB6, but am stuck with .Net.

[jesusdiehard]

thanx frnd
its working, just need little translation.

As far as creating addin in C# is concerned,
there are two ways
1. VSTO addin
2. Shared addin

VSTO is future but still little still not support all office applications like access.

main steps for creating shared addin

1 .In the New Project dialog box, expand Other Projects under Project Types, select Extensibility Projects, and then select the Shared Add-in template.
2 . Type xyz as the name of the add-in and then click OK.
3. When the Extensibility Wizard appears, follow these steps:
4. select Create an Add-in using Visual C#, and then click Next.
5. select the any host applications, and then click Next:

Automatically it wil generate a lot of code for u.
The class of interest is Connect class

add following reference in connect class

using Core = Microsoft.Offic e.Core;
using Excel = Microsoft.Offic e.Interop.Excel ;
using System.Windows. Forms;

I have just given here is just abstract description


these are two links to gud one to start with
http://support.microso ft.com/default.aspx?sc id=kb;en-us;Q302901
http://msdn2.microsoft .com/en-us/library/aa663367.aspx

just reply if there is any problem