LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 10th 05, 09:57 AM
Posts: n/a
Default 3 questions about automated c++ com add-in worksheet functions

I wrote a automated c++ com add-in to make my c++ functions available as
Excel worksheet functions. For further improvements I would like to know

1. Is there any way to retrieve a Excel::RangePtr to the cell calling the
current function? I used a VARIANT* for return value, but it is initialized
"VT_EMPTY" and does not yield any information about the caller.

2. How can I make an argument of my function optional (in Excel)?

3. Is it possible to add these little descriptions about function and
arguments to my own com add-in functions, like they are available for the
build in functions in the paste function dialog?

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Format Questions Mestrella31 Excel Discussion (Misc queries) 2 January 17th 05 08:36 PM
Questions about MS Word [email protected] Excel Discussion (Misc queries) 5 January 13th 05 03:49 AM
two quick questions on excel. please answer as soon as possible... Microofficetester Excel Worksheet Functions 6 December 17th 04 01:42 AM
newbie questions Eric Excel Worksheet Functions 1 December 14th 04 04:39 PM
2 Questions Beth Excel Worksheet Functions 3 December 1st 04 06:01 PM

All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017