Easy way to get activesheet, activecell and/or calling cell
625 views
Skip to first unread message
KY
May 5, 2009, 5:27:29 PM5/5/09
to ExcelDna
This is more feedback/request for enhancement, but it would be nice to
have an easier way to reference workbooks, worksheets, ranges,
activecell, etc. Im still new to ExcelDNA, but it seems the R1C1 way
of referencing a cell (or getting the active/calling cell) is more
difficult in ExcelDNA than VBA.
For example, I have a UDF function that gets data from another
application using sendkeys and then parsing the clipboard data. This
interaction is a little time intensive (2 - 3 seconds) and I'd like to
overwrite the calling cell (the activecell.value2 and formula). To
me, it seems there is no easy way to reference the caller.
have an easier way to reference workbooks, worksheets, ranges,
activecell, etc. Im still new to ExcelDNA, but it seems the R1C1 way
of referencing a cell (or getting the active/calling cell) is more
difficult in ExcelDNA than VBA.
For example, I have a UDF function that gets data from another
application using sendkeys and then parsing the clipboard data. This
interaction is a little time intensive (2 - 3 seconds) and I'd like to
overwrite the calling cell (the activecell.value2 and formula). To
me, it seems there is no easy way to reference the caller.
sverrirs
May 6, 2009, 6:45:35 AM5/6/09
to ExcelDna
Check out the ExcelDna.Contrib library has a nice set of wrapper
functions.
http://www.codeplex.com/ExcelDnaContrib
functions.
http://www.codeplex.com/ExcelDnaContrib
Reply all
Reply to author
Forward
0 new messages