Writing a DLL using Visual Studio 6 to return cell address!

  • Thread starter Thread starter agarwaldvk
  • Start date Start date
A

agarwaldvk

I am trying to write an Excel DLL for a function using Visual Studio
in C/Visual C++ that can be called from a worksheet cell.

This function would do something very similar to the built-in VLOOKU
function except that, the user can specify which occurrance of the loo
up value to find rather than always the first - as is the case with th
built-in lookup functions. Further, the user would also be able t
specify the column number where the lookup should be searched rathe
than this always being the first. I don't want to do this using VB
Excel - it is very slow that way particularly when the search array i
big.

In essence, I am looking for some help to be able to do to pass a
Excel range or a VBA (Excel) array to the DLL function and to be abl
to return the cell from the dll function . Whilst I know how to retur
the address from C, I don't know how to translate that memory addres
to Excel cell addresses.


Deepak Agarwa
 
Ron

Whilst your response is good, it is only applicable to Excel 2002 an
above. I, at present have access to Excel 97/2000 at work. Hence,
would need assistance in writing DLL's for Excel funcitons using Visua
C++ via VS6. Can you help?

Deepa
 
Back
Top