ATL Question

[Fredrik Wahlgren]

Hi

I have used ATL a couple of times to make excel autoamtion add-ins. So far,
I have only made functions that take simple arguments like strings or
integers. I now want to do so something a little more complicted. What I
have in mind requires that one of the parameters is an Excel Range object.
But I don't know how to do this. My guess is that I use something like an
IDispatch pointer and then edit the files manually. When I enter the
function in a cell, I want Excel ro recognize that the parameter should be a
Range

Anty help is appreciated.

/Fredrik

 

[Arnaud Debaene]

Hi

I have used ATL a couple of times to make excel autoamtion add-ins.
So far, I have only made functions that take simple arguments like
strings or integers. I now want to do so something a little more
complicted. What I have in mind requires that one of the parameters
is an Excel Range object. But I don't know how to do this.

use #import on the Excel tlb to generate a wrapper class around all Excel
types, including Range.

Arnaud
MVP - VC

 

[Fredrik Wahlgren]

use #import on the Excel tlb to generate a wrapper class around all Excel
types, including Range.

Arnaud
MVP - VC

How do Igenerate wrapper classes? Is there a site which explains how to
proceed? I assume this means I have to use MFC, right?

/Fredrik

/

 

[Arnaud Debaene]

How do Igenerate wrapper classes? Is there a site which explains how
to proceed?

As i said, use the #import directive. The doc is here :
http://msdn.microsoft.com/library/d...redir_The_.23.import_Directive.asp?frame=true

I assume this means I have to use MFC, right?

You assume wrongly...

Arnaud
MVP - VC

 

[Fredrik Wahlgren]

As i said, use the #import directive. The doc is here :
http://msdn.microsoft.com/library/d...redir_The_.23.import_Directive.asp?frame=true
You assume wrongly...

Arnaud
MVP - VC

I think I know how to do this know. I managed to implement an interface
written in C#. And sure enough, there was my Range parameter. I suppose that
if I wanted to create a function "Manually", using the wixzard, I would
select an IDsipatch pointer and then manually change it to Excel::Range. I
think that in VC6, you had to deal with the idl file as well.

/Fredrik