동구의 블로그

Sub 컨트롤아이디()
For Each cb In CommandBars
    For Each ctl In cb.Controls
        Cells(Rows.Count, "A").End(3)(2).Resize(, 5) = Array(cb.Name, cb.NameLocal, cb.Visible, ctl.Caption, ctl.ID)
    Next
Next
End Sub 

Application app = Globals.ThisAddIn.Application;

CommandBarButton delRowBtn = app.CommandBars.FindControl(Id: 293) as CommandBarButton;

CommandBarButton insertRowBtn = app.CommandBars.FindControl(Id: 296) as CommandBarButton;

delRowBtn.Visible = true;

delRowBtn.Click += rowDelBtn_Click;

insertRowBtn.Click += insertRowBtn_Click;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Diagnostics;

namespace ToStringOptimization

{

    class Program

    {

        static void Main(string[] args)

        {

            //클래스 메모리 미리 올려두기

            ToStringExtensions.ToStringLookup(1);

            Stopwatch st = Stopwatch.StartNew();

            for (int i = 0; i < 256; i++)

            {

                string s = i.ToString();

            }

            st.Stop();

            Console.WriteLine("ToString : {0}", st.Elapsed.ToString());

            st = Stopwatch.StartNew();

            for (int i = 0; i < 256; i++)

            {

                string s = i.ToStringLookup();

            }

            st.Stop();

            Console.WriteLine("ToStringLookup : {0}", st.Elapsed.ToString());

            Console.ReadKey();

        }

    }

}