Do we really like limitations..??

No, We don't ..!! its once again proved by  maarten have a look at this blog where he tells you how to remove convert the Clasic Worksheet to Extended Worksheet, and whats more if you have any confussion on how to convert it to VB .NET maarten comes back again to hold your hand, i guess i have a question for VSTO devs, if this was possible why we don't have an easier way to do it, and the the more important point here is the code we are using here looks scary, like for example  Me.VBProject.VBComponents.Item(1) is a pure workaround just to refresh the VBProjects associated with the workbook or when your try to search for help on New Microsoft.Office.Tools.Excel.Worksheet(hostprovider, RuntimeCallback, workSheet.CodeName, Microsoft.VisualBasic.Constants.vbNull, workSheet.Name) search Tools.Excel.Worksheet in MSDN and you will know that "Worksheet host items cannot be created programmatically. For more information, see Worksheet and Host Items and Host Controls Overview." but it still works...!! anyway i am happy maybe its a big question for VSTO guys

Comments (4)
  1. If you guys follow my post i discussed about marten’s way of converting clasic worksheet to extended…

Comments are closed.

Skip to main content