Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling sheet when usgin xlfCaller
Hi I am using the Excel SDK to write an XLL plug-in in C++.
I need to figure out the sheet my worksheet functions are using for my plug-in. I use the xlfCaller which gives me a sheet ref, i.e. without the sheetID. To get the sheetID I use the xlSheetID which gives me the ID of the active sheet. However the problem is if a function is referencing a cell in a different sheet. If I then change the referenced cell the function would give me the sheetID of the active sheet, which is different to the sheet it sits in. I have built a plug-in that attaches €śobjects€ť to my functions, but that means that I have to constantly know which cell every function is executed from. I saw that there was a proposed function xlCallerAddress that would do exactly this ( http://blogs.msdn.com/excel/archive/...13/664162.aspx ). However that was taken out before it was shipped ( http://blogs.msdn.com/excel/archive/...12/751080.aspx ) Is there any way of getting access to that function or get the sheet of the calling cell even if it isnt in the active sheet. Many Thanks, Max |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling name of Sheet as a Variable? | Excel Worksheet Functions | |||
Calling a Sub from Another Sheet | Excel Programming | |||
Calling a Sheet | Excel Programming | |||
usgin a macro within an IF statement | Excel Programming | |||
xlfCaller | Excel Programming |