Good afternoon, I created an Excel .xla addin for Excel 2002. This weird behavior I am seeing from it happens only on my machine, but not on my coworkers. I would like to understand why. The add-in has a UDF function that gets called from many, many spreadsheets. My Add-in is set to open when Excel opens. When I open a blank sprea...
Good morning, I have a .Net 2.0 runtime DLL that I am trying to load from Excel (it's correct regasm'd). I've verified with the Fusion Log Viewer that it is trying to load with the 1.1 runtime instead o 2.0, which explains why it's failing. One solution is to put an EXCEL.EXE.config file next to excel that looks like this: <?xml vers...
Hello all. I want to extract "special" data from an Excel 2002 (client requirement, cannot change) workbook and worksheets contained therein. I have classified ranges in this "special" data category. I would like to acquire a list of all ranges in, ideally, all worksheets in a workbook. The attributes I'm interested in are the range ...
Hi, I have just tried to send a workbook to a friend that has a chart with a drop-down box on it. In excel 2007 I have used: If Chart2.Shapes(2).ControlFormat.ListCount = "16" Then To check the size of the list so that it doesnt get entered in again (resulting in an extremely long list that repeats itself). This line works well in Exc...
Have built a toolbar for office xp, added buttons, wired up events and everything works fine. The problem is when I resize the Excel window so that the custom toolbar is truncated (and the truncated buttons appear into the double arrow dropdown), none of the buttons or drowdowns that are in the truncated dropdown fire. If I expand the ...