Excel Programming - All Comments

re: Well ... let's get started

newbie_2011 — Sat, 07 Jul 2012 04:36:23 GMT

your blog posts are very helpful for newbies like us!

re: How to code a .NET RefEdit Control

zqsntws — Fri, 02 Mar 2012 06:33:10 GMT

I have a question:If the form is a modal form, how to hide it when click refedit button?

re: Custom Task Panes

Matt Cope — Wed, 24 Aug 2011 09:53:49 GMT

hi gabhan

great article and i have managed to achieve this no problem.

i am now trying to extract the creation of the custom task pane out of the addin and into my own custom class which i can simply reference in the Connect method of the addin.

i pass a reference of the host application into my custom class and i also implement the ICustomTaskPaneConsumer interface there. the problem that i think i now have is that nothing is invoking the CTPFactoryAvailable method via the IQueryInterface of the ICTPConsumer, and therefore my code does not execute and create a CTP.

having read through your text several times i am stumbling on this to which i believe is the root of my problem... "When Excel loads our COM addin it performs a QueryInterface call to see whether or not our addin implements the ICustomTaskPaneConsumer interface. If it does, Excel calls the ICustomTaskPaneConsumer.CTPFactoryAvailable method. It is in this method that our addin creates the CTP. "

the fact that Excel makes QueryInterface call would indicate that it does this in the background. i have looked for any hidden code in the project to see how this is achieved and cannot find any. is it possible you could elaborate on this for me please. ie do i have to call the method myself, and how do i get a reference to the ICTPFactory object? or is this simply not possible and the ICTPConsumer interface can only be implemented in the actual addin itself?

thanks

matt

re: How to code a .NET RefEdit Control

XL-Dennis — Thu, 15 Apr 2010 16:42:40 GMT

Gabhan,

>>I am planning on providing the RefEdit control as a standalone

>>control.

Have You been able to do any work with it?

Kind regards,

Dennis

Excel Programming Open XML SDK Roadmap Announced | alternative dating

Excel Programming Open XML SDK Roadmap Announced | alternative dating — Wed, 17 Jun 2009 11:00:22 GMT

PingBack from http://topalternativedating.info/story.php?id=9777

re: Well ... let's get started

Calin naghi — Tue, 21 Oct 2008 12:14:32 GMT

Hi,

We are developing an excel addin and we facing some problems and maybe you can help us.

We have to draw in some cells some images and right now we are using shapes for that. We also tried with VSTO controls and that also works but we facing the problem that when we have a shape or a VSTO control inside the cell the user cannot select that cell from function dialog. So if he want's to introduce that cell in a function formula it can't select it by mouse.

It seems the controls inside the cells does not even receive any event like mousedown while the functions dialog window is activated. Do you know how we can workaround this?

re: Excel Event Handling in C#

2004.deepa@gmail.com — Sat, 27 Sep 2008 14:28:40 GMT

I want to hit the ALt+F8 key on active excel sheet using C# .net.

re: Using Cell Text to Filter PivotTables

Jason — Fri, 26 Sep 2008 19:32:10 GMT

Have you been able to modify the code for OLAP pivot tables? If so, can you please post it. Thanks.

re: How to code a .NET RefEdit Control

Dileep T M — Wed, 24 Sep 2008 17:27:05 GMT

Hai Gabhan Berry,

How can we make compatible this project with other lower office versions?.

Is that Microsoft.Office.Interop.Excel is necessary to interact with excel?.

Do you have any other method which is compatible to lower office version?

re: How to code a .NET RefEdit Control

Dileep T M — Tue, 23 Sep 2008 17:14:25 GMT

Hi Gabhan Berry,

I have some more doubts to ask also i need your suggestion. I will tell you my requirement , that is i have a C# DLL i am going to implement this Ref edit in my form and i need to show this form while executing one function in the XLA.So that i have exported one function. Then my concern is How to interact this C# form ( We are not using add-in ) to Excel and How to implement the event handling. Pls give your comments .... and how to support in office 2003